Remove entire rows if value exists in Column G

[aharvestofhealth]

I need a macro to remove each row in my spreadsheet if Column G contains a value. However, I need it to begin at G6 as G1-5 contains header details that I don't want removed. I have tried using the following macro, but haven't had much luck:

Please Login or Register  to view this content.

So to re-iterate, if Column G6:G contains a value, then I would like the entire row with the value removed.

[Legend Rubber]

Please Login or Register  to view this content.

Does this help?

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[HaHoBe]

Hi, aharvestofhealth,

why not use the Autofilter for that? If the values are really values (not formulas) you could use SpecialCells(xlCellTypeConstants, 23) for getting the range to delete.

Ciao,
Holger

[aharvestofhealth]

Much appreciated guys!