Hide columns and rows using count rows/colums

Closed
rdebois - Jul 9, 2010 at 09:21 AM
rizvisa1 Posts 4478 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




Related:

1 response

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