Testing objects

andyh69uk

New Member
Joined
Nov 23, 2005
Messages
31
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??
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Watch MrExcel Video

Forum statistics

Threads
1,118,534
Messages
5,572,743
Members
412,482
Latest member
arooshrana2
Top