Thanks for the support,please help I have attached the code that I tried doing the below

My goal is to refresh the pivot tables of a worksheet, when changes are done to some cells. These cells contain percentages which influence the pivot tables, and are the only cells that are edited.
This is the code I have so far, but when I run it, it gives me this error: “Run-time error ‘424’: Object required”, and it points to Line 4.

I want to have a vba code that auto hiding range row 1-10 in worksheet B if len cell B(1-10) is < 1 (null)

The following simple code sets up .OnEntry on the active sheet to run macro DCCapture. When I edit a cell and hit the enter key, it works and selects cell 4,4. When I edit a cell and use the formula check instead of the enter key, I get run-time error ‘50290’ Application-defined or object-defined error. The macro does nothing but select a cell. Here’s the code,

I have an excel, that is used to record daily flow of business. In the A column is the date of registration and in the other columns information about the item.
I need to put borders below the row of each last date, to visualize the individual dates better. This should looks something like this.

i’m trying to rename files in a specific folder, using a list of new names in a column of an excel file.In the following code i’ve tried just with one file without loop. It returns ‘runtime errore 53’ – ‘impossible to find the file’. What i found confusing is that in the error line ‘name nome_vecchio as nome_nuovo’ the pop up is giving me the right names.
Thank you in advance for your help.

Hope all good with everyone.

I’ve been successfull using this macro for downloading pictures and renaming them with a text included in a related cell:

I am using the below code to delete cells and autofit all columns in multiple sheets to default size. I am not a good writer of codes but used this to get results. My query, Is there a way to do this with better code.

I am trying to copy and paste all cell values in column A ABOVE specific cell value “QUESION”. I tried the below code which copies all cell values BELOW the cell value “QUESTION”. I could not figure out how to copy the cell values above. Any help will be much appreciated.