if range=nothing then

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I don't know how to use an if structure with arange:

rngEndCell is a range

If rngEndCell = Nothing Then
ssss = Cells(47, columna).Address(False, False)
Set rngEndCell = Range(ssss)
End If

the error 91 appears

how to accoplish this???
 
You will need:
If rngEndCell Is Nothing Then
as rngEndCell is an object, a range object.

RBS
 
Back
Top