Hi
I have a macro that filters a range of data.
Is there a command that will highlight only the filtered data, and ignore the hidden (unfiltered) data?
Thanks
Hi
I have a macro that filters a range of data.
Is there a command that will highlight only the filtered data, and ignore the hidden (unfiltered) data?
Thanks
Once you filter the data, it will highlight the visible cells Only. Select all and highlight all. I am assuming you are using Excel's filter function
I think the command I need is, which seems to highlight only the visible cells.![]()
SpecialCells(xlCellTypeVisible)
Thanks anyway.
You do not need the command either. If you filter the data, the default data are SpecialCells(xlCellTypeVisible)
Thanks, it only worked using the command. Anyway, all sorted thanks for your efforts.
For e,g
AutoFilter 3, "2"
filters field 3 by a criteria of 2.
After this line, I do not need to specify the special cells. I just do what ever I want to do with out special cells.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks