| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to check whether cell has #REF ! error?
Dear Friends,
I want to check whether cell has #REF ! error? I am trying to get the values of a cell range. If any cell has an error "#REF!" then "ActiveCell.value" fails. Whats a way to check whether cell has an error so I can consider any default value for that cell. Regards, Vinit |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check or uncheck a check box based on a cell value | Excel Discussion (Misc queries) | |||
| Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
| Check for error.type in same cell | Excel Worksheet Functions | |||
| Color cell if spell check finds an error | Excel Worksheet Functions | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
![Vinit[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
