Hi,
I am new to VBA/Macros and am looking for some help please.
I have a spreadsheet where I would like the rows to hide/unhide automatically based on a value in a column (either 0 or 1). The value is driven by a formula. I want rows with 1 value to display (unhide) and rows with 0 value to hide. I also want to be able to apply the macro to a range of rows but for it to ignore (ie keep displayed) rows where the column value is blank.
Attached is a simple example. Can anyone help me with the code please?
Thanks
Kim
Bookmarks