if range=nothing then


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???
 
Ad

Advertisements

R

RB Smissaert

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

RBS
 
Ad

Advertisements

G

Guest

Thanks silly me¡¡¡¡

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

RBS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top