Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing a range for blanks
I have a spreadsheet that has 5000+ rows. Some of the rows have cells 3-10
as blanks. I need to report when these cells are blank. Is there a simple way to test the range for blanks or do I need to cycle through each cells and evaluate them? Thanks in advance. Guy Normandeau |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TESTING A RANGE OF CELLS | Excel Worksheet Functions | |||
Testing for a consistent value counting blanks | Excel Worksheet Functions | |||
copy range of cells with blanks then paste without blanks | Excel Worksheet Functions | |||
testing whether the ActiveCell is in a given range | Excel Programming | |||
Testing for content in Range | Excel Programming |