View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Catherine Bond
 
Posts: n/a
Default How to code Macro for hiding rows

Hello!

I need help with some macro coding, as I am new to it.

Here is the basic breakdown:
I have 50 rows of data space.
Some rows do not have date.
I need to hide the rows which don't have data.
If I could code it by dictation, I would say "If A2 is empty, hide the row.
Do the same for A3 through A50"

Any suggestions??