Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

Counting cells containing only numbers
jutulu -
jutulu -

4 responses
Copy row and insert n times
Islandman -
sandy -

46 responses
how to count sentences in a paragraph..." using c language
gealon2024 -
indhu -

4 responses