Why does this return an error?

Dim Unknown As Range
Unknown = Range("K24")

oldjay

Range is an object and so you need to use the Set Statement which assigns an
object reference to a variable or property. Refer help on Set statement....

Dim rngTemp As Range
Set rngTemp = Range("K24")
'will refer to the activesheet cell K24

--
Jacob


"oldjay" wrote:

Why does this return an error?

Dim Unknown As Range
Unknown = Range("K24")

oldjay

Thanks I never know where to look in help. I think Help is for experts not a
dummy like me

"Jacob Skaria" wrote:

Range is an object and so you need to use the Set Statement which assigns an
object reference to a variable or property. Refer help on Set statement....

Dim rngTemp As Range
Set rngTemp = Range("K24")
'will refer to the activesheet cell K24

--
Jacob


"oldjay" wrote:

Why does this return an error?

Dim Unknown As Range
Unknown = Range("K24")

oldjay