Testing objects

[andyh69uk]

Does anyone know how to test if a range has been set, eg

Dim newRange as Range
.....some code......possibly including set newRange = etc.
If IsSet(newRange).
Somthing to replace this non-existent method.

I have tried =nothing but it thinks i am trying to set the range to nothing, I have also tried isNull, isEmpty but no joy

Any ideas??

 

[Andrew Poulsom]

Close

If newRange Is Nothing Then

 

[andyh69uk]

IS IS IS IS IS IS IS!!!!!!!

Thanks very much