Hide columns and rows using count rows/colums

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
New to VBA/Macros

Trying to hide all rows and columns not being used in a sheet that has a fixed/finite design.

Because this will be used in 2003/2007/2010 excel, need to have variable set for rows/columns hidden.

last row is 605, last column is AY everything below and to the right needs to be hidden.

?any suggestions?

Thanks in advance for your assistance!

RLD




1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Since you know what is your range why dont you hide the rows and columns?
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month