not checking all cells

[Curt]

did this with macro recorder it does not shade all cells.
those not shaded are spread around on sheet. Want to do this to see if data
missing before merge for mailing
Thanks
Sub blanks()
' blanks Macro
' Macro recorded 6/28/2007 by Curtiss A. Greer
Worksheets("Data").Range("a4:m60").Select
Selection.specialcells(xlCellTypeBlanks).Select
End Sub

 

[Doug Robbins - Word MVP]

I suggest that you post your question to the
microsoft.public.excel.programming newsgroup. This one is for questions
about the use of VBA in Word.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP