Using code to delete rows with blank cells in them upon opening the workbook

Hey,

In Column C:Column H there could be blank cells. I would like to delete the entire row that has blank cells.
I'm going to be passing this spreadsheet on for someone to use so I would preferably like this to happen when you click one command button.
Any ideas?

(Novice VBA'er - assume knows nothing :P)

Thanks,
Marie-Louise

Maybe:

Please Login or Register  to view this content.