Hide columns and rows using count rows/colums

Closed
rdebois - Jul 9, 2010 at 09:21 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jul 9, 2010 at 04:56 PM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
768
Jul 9, 2010 at 04:56 PM
Since you know what is your range why dont you hide the rows and columns?
1