| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
== How to test if a range var contains nothing
I need to check if a certain range var is nothing.
Suppose you have the following code Dim R As Range If R = Nothing then End If When I try to compile this I receive and object error in the If line. Then how can I test if R has something. Finally IsNull and IsEmpty don´t work too. Regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Test if a value is in a range of values | Excel Worksheet Functions | |||
| Test within a range? | Excel Worksheet Functions | |||
| Test if CELL is in RANGE | Excel Worksheet Functions | |||
| How I set up as logical test if my range has to be >=2 but <5 | Excel Discussion (Misc queries) | |||
| Test if Cell is within Range (name) | Excel Programming | |||
![hcova[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
