variable as range address

[smakatura]

I want to set a variable to a range address (C68). when I do

Range_Variable =Range ("C68")

I get the value that is in C68 no a cell reference (R1C1) that an be used as an address in formulas

this is probably very simple but I have not found the answer

 

[Fluff]

It needs to be

Range_Variable =Range("C68").address

or simply

Range_Variable ="$C$68"

 

[smakatura]

thank you. I knew it was not difficult but for the life of me could not find it

 

[Fluff]

You're welcome & thanks for the feedback