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)
|