View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] eirens@gmail.com is offline
external usenet poster
 
Posts: 4
Default Macro to hide rows/colums by value

HIDING
I'd like to be able to hide various rows and columns that have the
number 1 in their first position.

For example:

If A4 =1 then hide row 4.

If B6=1 then hide column B.

I'm okay with never being alble to hide row 1 or column A so there
shouldn't be any conflict/ambiguity.

UNHIDING
I'm happy to just unhide all when I need to unhide any. How can I do
that?

Would someone point me in the right direction?

Thanks for any help.

/e