You will need:
If rngEndCell Is Nothing Then
as rngEndCell is an object, a range object.

RBS

"filo666" wrote in message
...
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???