Hide Empty Rows

[hheyerdahl]

I have read and searched a lot of posts but I am not familiar with VBA and am having a hard time finding a code I understad and can tweek.

I have a sheet with cells calculated by formulas and I want to hide an entire row if column A (calculated by formula) is "" and unhide it if a value is entered into the cell (again, by formula).

I have written a code for individual cells

Please Login or Register  to view this content.

but I would like this to be applied to Rows 43 through 120 with out manual entering in that code for each individual row.

I appreciate any help.

[judgeh59]

this may work for you

Please Login or Register  to view this content.

[hheyerdahl]

This did work! Thank you for the help!

[judgeh59]

glad I could and thanks for the rep points....have a great day....