Code to hide row

[Excelski]

Hi,

I would like some code please that hides the entire row when a date is added in column E first row is E5

I would like to be able to hide and unhide all hidden rows based on a check box in O2

Any help greatly appreciated

Thanks
Kevin

[ranman256]

this code hides the cells if there is a value in Cell O2.
and it assumes there are values in col A. It moves down A until it runs out of data, hiding rows on the way.

Please Login or Register  to view this content.

[Excelski]

ranman256 works great, thank you!

Kevin

[jolivanes]

Sorry. Wrong Post