Hi Experts
I have a table where I have rows grouped above and below and only few rows remain visible. (I'm attaching table picture for reference)
Now I need a vba where I could select all visible rows - Leaving one from above and one from below.
As in this Picture - Rows 1169 to 1181 are visible and I need to select table rows from 1170 to 1180.
At times I need to do that many times a day so thought working with macro will make it convenient.
Please help.
Thanks
Screenshot 2018-11-21 at 20.27.59.jpg
Bookmarks