Dynamic Row Hiding Macro

[djl295]

Hello,

I am trying to code part of a macro that hides rows in several ranges when a cell in a particular column of that row is blank. Any ideas?

Thanks in advance for any help.

[Kramxel]

Please Login or Register  to view this content.

i'd suggest putting this in the calculation module.

[djl295]

But I only want the rows hidden when the macro is called. So this would just go at the end of the macro?

[stnkynts]

I would avoid utilizing the calculation event. If you want this to trigger automatically you would probably want to assign it to the worksheet change event and specify a "Target" range. With that being said, If you want it to only be run when you execute the macro something like this would work.

Please Login or Register  to view this content.