Hi
I have two constant values (6 is start row and 50 is end row) and one variable value in cell A1 which is for example (23).
What is easiest way to unhide all rows between 6 and A1(23) and hide other rows between A1(23+1):50 ?
Thanks in advanced
Hi
I have two constant values (6 is start row and 50 is end row) and one variable value in cell A1 which is for example (23).
What is easiest way to unhide all rows between 6 and A1(23) and hide other rows between A1(23+1):50 ?
Thanks in advanced
Usually, I insert a column. Put 'Hide' in what cells you want hidden. Then filter the data and show BLANKS (uncheck 'Hide').....then when you want them all back, show all or check both Blanks & Hide. the filter is on the data tab.
Hi nikobelic1,
If you're looking for VBA, try below code ...
Please Login or Register to view this content.
If I was able to help, you can thank me by clicking the * Add Reputation under my user name
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks