finding/highlighting empty cells

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

Hello ...

Here's the issue, I have a workbook with 7 worksheets,
each has 100's of fields of information, calculations,
etc. The first worksheet is a summary of the other six,
with all of the key values and information from the sheets
( 704 fields ) compiled and posted.

Is there anyway to program the summary sheet to identify
(by color background or another very visable method)cells
that are blank, so I can go back and see what wasn't
posted?

Effectively, I need to know how to quickly ID missing
information, prior to completing the project.

Any advice or direction appreciated.

regards,

Patrick
 
Use menu Edit/Goto/Special ... Blank which will select empty cells.

Or something like this line of code in a macro :-
Selection.SpecialCells(xlCellTypeBlanks).Select

Regards
BrianB
================================================
 
Back
Top