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??
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??