View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hcova[_2_] hcova[_2_] is offline
external usenet poster
 
Posts: 3
Default == How to test if a range var contains nothing

I need to check if a certain range var is nothing.
Suppose you have the following code

Dim R As Range

If R = Nothing then
End If

When I try to compile this I receive and object error in the If line. Then
how can I test if R has something. Finally IsNull and IsEmpty donĀ“t work too.
Regards