Constant Row Hiding Macro

[djl295]

Hey guys,

I need a macro that hides rows in a worksheet when..

Indirect(C&Row())=""
AKA When that rows corresponding cell in Column C is equal to ""

Also, does this macro need to be enabled by a button? or is it possible to have it running on a continued basis (each time the sheet is recalculated hiding and unhiding blank and unblank columns.

Thanks so much in advance.

[bmouse]

I just wrote something similar:

Please Login or Register  to view this content.

Unfortunately this kind of macro requires a button press, I do not know, how to make them run indefintely on opening the file.

[bmouse]

Found a way to run it without a button press, it runs every time you make changes.
I did not fully understand the thing about the targer cell, in this case it is C2.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[djl295]

What I meant is that it decided to hide or not hide the row based on if C in that row is blank.

Example: In order to decide if I should hide row 3 I would Check if c3 is blank, in order to decide row 4 I would check if c4 is blank, ect....

[bmouse]

StartNumber is the number of your first row.
EndNumber is the number of your rows in total.
Be careful though, this macro runs every time you change something, and if C is empty, it will hide the rows automatically. I set EndNumber to 10, so that it wouldn't look past row 10.

Please Login or Register  to view this content.