I have a sheet with the Filter on and the filter value set. I am selecting the filtered cells as a whole.
But I dont want the header line selected. I am not able to figure out the code for the same.
need Help!!!
Thanks!!
I have a sheet with the Filter on and the filter value set. I am selecting the filtered cells as a whole.
But I dont want the header line selected. I am not able to figure out the code for the same.
need Help!!!
Thanks!!
do you only want to selecte the filtered data, or do you want to include the unfiltered lines as well?
this will only select visible data
Range("A2:E200").SpecialCells(xlCellTypeVisible).Select
where A2:E200 is the full range of your data starting bellow your headers
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
Hello and welcome to the forum!
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks