Thread: Automate Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chiku
 
Posts: n/a
Default Automate Macro

I have a macro that hides blank rows whenever there is no value in a
particular cell. How do I program the macro to run every time someone adds a
value in any of the cells that determine whether its row should be hidden? In
other
words, column B contains the cells in which when blank, the row is hidden.
Now I want to unhide the row if someone enters data in the cell in column B.

(Let me know if I need to explain some more)