Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Don't use IsNull. Instead, use Is Nothing.
Dim rRange As Range Set rRange = Nothing ' yes, in debugger If rRange Is Nothing Then MsgBox "rRange is Nothing" End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Peter Chatterton" wrote in message ... Public Sub testNullRange Dim rRange As Range Set rRange = Nothing ' yes, in debugger If IsNull( rRange ) Then _ MsgBox "DOESN'T COME HERE" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I test for nulls within a range without specifying each ce | Excel Discussion (Misc queries) | |||
Test within a range? | Excel Worksheet Functions | |||
How I set up as logical test if my range has to be >=2 but <5 | Excel Discussion (Misc queries) | |||
== How to test if a range var contains nothing | Excel Programming | |||
Test if Cell is within Range (name) | Excel Programming |