Windows XP If statement to delete blank rows until second to last row

[smu04sew]

Morning

I need to analyse the rows within data, where the number of rows vary each time. I need a code which basically says:

if the row is the second to last row, then stop
else if the cell in column G of that row is empty, delete row
else do nothing

I have various bits of code in order to find the Last Row, so defining that isn't a problem, i'm just unsure of how to do the rest of it.

Thanks