Ways to refer a cell location

[SpringLily]

Hi, All
See the code below:

Please Login or Register  to view this content.

if I would like to use the format "'C5.2'!K23" for refering the cell location, I have to change "RefersToR1C1" to something. Does anybody know what it is?

Thanks
Lily

[TMS]

Have you tried "RefersTo" ?

Regards

[SpringLily]

Thanks. TMShucks. My mistake. The string for the name I used was wronge. Regards, Lily

[davesexcel]

Just an added note
try,

Please Login or Register  to view this content.

A lot simpler to use.

[SpringLily]

Thanks, Dave. This is helpful!