Delete rows with conditions

Hi,

I know there are few threads on this problem. I've tried some of them but couldn't get the solution to my problem.

In my worksheet, column G5:G100 which I have defined as "Amount" contains numbers and blanks. I want a macro where I can delete the whole row for cells that contains 0 and blanks.

Would be grateful if somebody can help me with this problem.

Thanks in advanced.

Hi

Try

Please Login or Register  to view this content.

rylo

Hi
try these codes

Please Login or Register  to view this content.

Ravi

Hi Ravi,

Thanks but how can I incorporate a named range in the macro? I've named the cells range as "Amount". I need to have a named range because the cells i wanted the macro to check would always change.