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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
== How to test if a range var contains nothing
Hi
one way: If application.count(r)=0 then 'nothing end if -- Regards Frank Kabel Frankfurt, Germany hcova wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
== How to test if a range var contains nothing
if R is Nothing
not if R = Nothing "Frank Kabel" wrote: Hi one way: If application.count(r)=0 then 'nothing end if -- Regards Frank Kabel Frankfurt, Germany hcova wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
== How to test if a range var contains nothing
Is Nothing has a specific meaning in VBA, namely that the object variable has
never been set. Is that what you are after? If so, the syntax is If R Is Nothing Then OTOH, if you HAVE set R to point to a range, and you want to know whether that range is empty, Set R = Range("A1:A250") If Application.COUNTA(R) = 0 Then On Mon, 25 Oct 2004 13:03:07 -0700, "hcova" wrote: 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 |
Reply |
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 |