how to hide a row based if a cell is empty

[Levi@ai]

i wasted all day trying to figure this out i have a workbook with 4 pages i need to make a macro that would hide a row only if the third column is blank.
im new to forums and to VBA
can someone help me out

[jeffreybrown]

Hello & Welcome to the Board,

How about...

Please Login or Register  to view this content.

[Levi@ai]

wow thanks.

now how do i unhide?

and is there a way that if the column a is blank then it should not hide it?

[jeffreybrown]

How about this...

The first macro will hide all rows where a cell in column C is blank and a cell in column A is not blank. Did I read your requirement right?

The second macro will unhide all rows.

Both macros will also perform this on all worksheets in your workbook.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Narasimhan19]

Hi thanks for this. But i have column c & d. i want to hide rows only when both columns are either "0" value or "blank" value. How to write please