View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
New2Macros New2Macros is offline
external usenet poster
 
Posts: 22
Default Macro to show/hide rows

I need to use a single cell to show/hide other rows. For instance if you put
a "6" in cell B1 it would show the next 12 rows and hide the rest. If you
put in a "10" it would show the next 20 rows and hide the rest, etc.

I'm new to writing macros, sorry!