ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Automate Macro (https://www.excelbanter.com/excel-discussion-misc-queries/60462-automate-macro.html)

Chiku

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)



All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com