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

RB Smissaert

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

Similar Threads

0 considered as empty 3
clipboard excel 2
Object range failed 1
Run Macro If Cell have "x" value 0
Macro converts time entered in column E and F from Indian time to CST( without daylight saving) 1
Copy numbers from an array, each to it’s own sheet 4
Excel 2010 Sendmail .Display works, but not .Send --- Please help 2
Sharing xls file with macro (xlsm) 0

Top