Solved: Help Identifying Empty Cells

[JayDP123]

Hello,

I am looking to create a function to search through Column C of my spreadsheet and identify the empty cells which appear every once in awhile, and then to display the entire rows which these empty cells belong to in a new worksheet.

Thanks

[Simon Lloyd]

This one line of code will display all the entire rows of the cells found in column C that are blank on sheet 2:
ActiveSheet.Columns("C").SpecialCells(xlCellTypeBlanks).EntireRow.Copy _
Destination:=Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)

[JayDP123]

Thank you kindly