Highlighting blank cells

[Ellen 2Excel]

I am new to VBA and cannot seem to get the code right to do the following:
Range is C2 to end of column, including blanks
Find the blanks
For each blank cell,
.Interior.Color = 10066431
.Borders(xlLeft) = -16777024
.Borders(xlTop) = -16777024
.Borders(xlBottom) = -16777024
.Borders(xlRight) = -16777024
Finally, I want to return a message to the user the cell addresses that are blank.
"The following cells are blank: C4 (or $C$4), C8, C100, C120, etc.)

Can someone provide some guidance? My code seems to move all the blank cells to the bottom, and I'm not sure how it's even doing that.
Thanks!

[stnkynts]

Try this:

Please Login or Register  to view this content.

[notreallyIT]

Better answer above!

[Ellen 2Excel]

I copied that into mine, but it stops on
For Each rCell in Range("C2:C" & Range ("C" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeBlanks)
I get "Unable to get the SpecialCells property of the Range class" - see attached

12-5-2013 11-25-13 AM.jpg

[stnkynts]

It would only do that if there are no blank cells in range C2:C and the last used row. Is there only 1 worksheet (ie is it referencing the correct sheet). Are you sure its column C.

There could be many things causing this. I would recommend submitting a copy of your workbook as the code worked just fine on a test workbook.

[Ellen 2Excel]

Here is my sample worksheet.

[stnkynts]

It worked just fine for me on your sample spreadsheet. Here is another way of doing the same thing which may bypass whatever problem you are having:

Please Login or Register  to view this content.

[Ellen 2Excel]

OK I got it run successfully and it highlights all the blank cells, except for C2 and C3. For some reason, it doesn't see C2 and C3 as blank cells. If I clear contents on those two cells and rerun the code, it works perfectly.