Range error

  • Thread starter Thread starter oldjay
  • Start date Start date
O

oldjay

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
 
Thanks I never know where to look in help. I think Help is for experts not a
dummy like me
 
You must log in or register to reply here.

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

Can't activate an existing workbook 6
VBA set thick borders around non empty cells in range 0
HOW TO PROMPT MSGBOX JUST ONCE 6
Vatiable range 4
Run- time error 1004 2
'1004' - Application defined or Object defined 2
Automatically extending a range 1
Easier Way to Macro Total 4

Back
Top