Macro to hide rows based on ISBLANK condition

[phbryan]

Good morning,

I need a macro to automatically hide rows based on the condition that a cell is blank.

For example, if cell A3 is blank in the range A1:A10, hide row 3.
The range is important, as i only want the macro to operate within the range.

Thanks

[Olly]

Try:

Please Login or Register  to view this content.

[phbryan]

Getting an "subscript out of range" error on

Please Login or Register  to view this content.

[phbryan]

Never mind got it to work,

Code works great!

Thanks

[Olly]

You did change the worksheet name, didn't you?!