View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jackie Jackie is offline
external usenet poster
 
Posts: 78
Default Macro to perform action based on value in cell

Hi-

I am trying to create a macro to hide rows based on the text value in cell
A1.
If A1 = N/A, hide rows 48 through 56. Sheet is called Monthly Statement.
A1 has an iserror formula that returns N/A if an error and a number if not.

Thanks.