range objects

[damonh]

Hey,

If I set a range object as referring to the cell A1 in a
spreadsheet and then delete the first column, will the
object reference be deleted or will the object still point
to A1?

Thanks in advance

damonh

 

[Bob Phillips]

Hi Damon,

Absolutely not, the range object will not be valid once the column is
deleted.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Jan Karel Pieterse]

Hi Damonh,

If I set a range object as referring to the cell A1 in a
spreadsheet and then delete the first column, will the
object reference be deleted or will the object still point
to A1?

In Excel XP the object will be destroyed.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Dan T]

Completely accept what you say but could you clarify
the "but what is it" in the following

Sub test()
Set r = Range("a1")
Columns(1).Delete
'r.Select 'fails
MsgBox Not r Is Nothing 'true but what is it?
Set r = Nothing
MsgBox Not r Is Nothing
End Sub

Thanks,
Dan

 

[Bob Phillips]

r is a variable that is not nothing, but is not a valid object either, so it
is returning 'Object required'

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Dan T]

Uhm, so it's something of nothing

Dan

-----Original Message-----
r is a variable that is not nothing, but is not a valid object either, so it
is returning 'Object required'

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.

 

[Bob Phillips]

No that is what it is not, nothing is a something in objects<vbg>

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)