Set reference to other sheet?
 

How can I set a reference to a cell on "MySheet5" cell A:5 ?

Set reference to other sheet?
 

Hi
dim rng as range
set rng = worksheets("mysheet5").range("A5")
msgbox rng.value

--
Regards
Frank Kabel
Frankfurt, Germany

"HotRod" schrieb im Newsbeitrag
...
How can I set a reference to a cell on "MySheet5" cell A:5 ?

Set reference to other sheet?
 

Hi HotRod;

You can use this:

Sheets("MySheet5").Range("A1") = "HotRod"

Thanks,

Greg

-----Original Message-----
How can I set a reference to a cell on "MySheet5" cell
A:5 ?


.

Set reference to other sheet?
 

Sorry I asked this question in the wrong group. I was wondering how to add
an reference in excel, not in VBA. SORRY

Set reference to other sheet?
 

Hi
then what do you mean with 'add a referece'? Maybe
='my sheet5'!A5

--
Regards
Frank Kabel
Frankfurt, Germany

"HotRod" schrieb im Newsbeitrag
...
Sorry I asked this question in the wrong group. I was wondering how
to add
an reference in excel, not in VBA. SORRY