O oldjay Dec 11, 2009 #1 Why does this return an error? Dim Unknown As Range Unknown = Range("K24") oldjay
J Jacob Skaria Dec 11, 2009 #2 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
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
O oldjay Dec 11, 2009 #3 Thanks I never know where to look in help. I think Help is for experts not a dummy like me
