Hi guys.
I have a problem which i cannot solve.
In VBA code.
I need to filter a column ("D"), select filtered cells (de-select "Blanks" from list), copy filtered data, and past them in the same place with "Paste Special Values".
This action is intended to remove formulas from selection and paste them as values in the same place.
Every time i try to do this, i get a message that the cells area is not the same size.
Another way is to copy only cells with data and paste them in the same place, this way i could save the remaining formulas to the next job.
Help Please.
All the best
Bookmarks