Hey
Im currently in the process of editing a huge spreadsheet, step by step, and its proving to be a huge task.

I was wondering if there is a macro out there, or if anyone can help with one, which will delete an entire row (not just remove its contents and leave it blank, delete the row and shift it up), if the cell on that row in column "G" is empty.

The idea basically would be the code would work through every line of the spreadsheet, deleting any rows with a blank cell in the "G" column.

so i guess it would include "Selection.Delete Shift:=xlUp" somewhere in the code...?

any help would be apreciated?

thanks