Hi All,
I have a page setup which has an advanced filter.
At this stage, the filter works fine.
I am then using a simple macro to copy and paste values (so there are no formulas been copied etc) from another page into the appropriate parts of the criteria range of the sheet.
I am then hoping to run the advanced filter based on these values which have been copied and pasted into the criteria range.
As far as I am concerned, if I copy and paste data as a value, it should be no different to me just typing the data in?
As soon as I do this and run the filter, all cells in the list range disappear.
This happens even if the macro is copying and pasting completely blank cells.
If I then highlight the criteria range (which at this stage looks completely blank) and press delete and then run the filter again it works - or at least all the data comes back.
Can anyone help ????
Bookmarks