Store selected range in string variable

[wmbb]

How can I store a selected range (in excel)in a string variable like "Sheet1!$KR$3:$KT$8"

 

[PHV]

Use the Address property of the Range object.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

hi,

Another option is to Name the range using Formula > Defined Names > Name Manager or using the Name Box after having selected the target range on the target sheet.

Then referencing that NAME in any formula on any sheet will refer to that range on that sheet.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[wmbb]

Thanks for pointing me in the right direction !