VBA- Code to delete rows where there is content in Column C

[ExcelRookieIre]

Hi,

I'm really stuck for some VBA code to help me build a macro that will delete any row where there is content in Column C. Can anyone here help me , I would really appreciate it.

ExcelRookieIre

 

[MickG]

Try:-

Range("C:C").SpecialCells(xlCellTypeConstants).EntireRow.Delete

 

[ExcelRookieIre]

Thanks MickG that's fantastic.

Cheers,

ExcelRookieIre

 

[MickG]

You're welcome