not checking all cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Curt - 29 Jun 2007 00:02 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 29 Jun 2007 09:40 GMT

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.

Signature

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

> 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
[quoted text clipped - 7 lines]
> Selection.specialcells(xlCellTypeBlanks).Select
> End Sub

Reply to this Message