| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is the cell really blank?
Excel 2002, WinXP
I've been using If Range(....)="" Then to check if a cell is blank. I realize that this check is good only for a blank cell, not for a cell that contains a formula that returns a blank cell (True in both cases). I've also used: If IsEmpty(Range(....)) Then and this has been working well including the formula case above (returns False if it contains the formula). However, I've seen on this newsgroup that "IsEmpty" should only be used to determine if a variable has been initialized. Can anyone clarify the use of IsEmpty to determine if a cell is truly blank? Thanks for your help. Otto |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return a blank formula cell if the reference is blank? | Excel Worksheet Functions | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| how to get excel to display blank if reference cell blank | Excel Worksheet Functions | |||
| How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Threaded Mode
