Thread: Can't test Range for Nothing
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Chatterton[_4_] Peter Chatterton[_4_] is offline
external usenet poster
  
Posts: 20
Default Can't test Range for Nothing
Public Sub testNullRange
Dim rRange As Range
Set rRange = Nothing ' yes, in debugger
If IsNull( rRange ) Then _
MsgBox "DOESN'T COME HERE"
End Sub


Reply With QuoteReply With Quote