unable

First, let me say thanks in advance for looking at this for me. I've been racking my brain trying to figure this out error and I'm stuck. Below is my code which I am getting the, "Run Time Error '1004': Unable to set the Hidden property of the Range class". What is interesting is that the...

I have a spreadsheet that I use every day to format a set of data. I open the spreadsheet, import a CSV file, then apply some formatting before distributing a very simple report. Once in a while I will make a mistake and have to delete the contents of the sheet and start over again. The...

Hi, I want to extract data of a particular Website through its API but i am unable to do so. Is it possible ? If yes please help me out.

Excel screen size has shrunk and is unable to maximise the same. The minimise and maximise tabs are missing

Dear Fellows, Good Day! I have some data in excel which looks like a number but I remain unable to do any mathematical operation on them. More interestingly the written numbers cannot be deleted once in editing mode( by pressing F2). I have tried to change its format and then convert it using...

I searched this forum and many others with the same results. I am unable, using the attached sheet, to place a vertical perpetual moving date vertical line. Many different tutorials explain ways to achieve this but I believe I am unable to replicate because of how my Gantt chart is designed...

I’m really hoping someone can help me to modify the below code – which should automatically populate (with data from my spreadsheet: Sheet2) 4 Textboxes (Reg2 – Reg5) in my Userform AFTER matching the value (Full Name) in my Combobox (Reg1). The issue is: Currently I am unable to get the...

I have generated a lot of workbooks which enable management of some engineering projects. The workbooks include many spreadsheets which assist Project Managers with control of their project, eg. Programming, Financial control, Briefs and Responses, Projects Notes, Safety Audits etc. etc. Each...

When I record a macro to remove a data field from a pivot table, I get this: ActiveChart.PivotLayout.PivotTable.PivotFields("Sum of orders").Orientation = xlHidden I then return the pivot table to the exact state it was in before I recorded the macro and run the exact code that was recorded...