Set reference to other sheet?

[HotRod]

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

 

[Frank Kabel]

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

 

[GJones]

Hi HotRod;

You can use this:

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

Thanks,

Greg

 

[HotRod]

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

 

[Frank Kabel]

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