Thanks for your efforts so far guys, but I get the following message:
Run-time error '424':
When I debug, the "For Each c In UsedRange.SpecialCells(xlCellTypeBlanks)" line is highlighted.
The macro I have so far does this on a different sheet in this workbook ...
- checks there are no errors in data that humans put in column A,
- sorts the data
- spaces it nicely so it is presented nicely to humans.
At this point I am using the following code to switch to the required sheet where the blank spaces are (followed buy your code).
For Each c In UsedRange.SpecialCells(xlCellTypeBlanks).Select
c.Interior.ColorIndex = 8
vcoolio's answer does indeed perform the same action on all empty cells.
I am sure you are correct and I am close in getting what I want, but I just cant make that final jump.
I'll keep trying and researching, but if you could spell it out so a blind man could see, then I would be so happy that I would buy you a drink (tea/coffee) whenever you asked me!
Thanks for your time and help.