Hi:
Using Excel MACROS,
Application.Goto Reference:="TEMPLATE!R18C2"
where "TEMPLATE!R18C2" changes all the time and comes from a function =ADDRESS(MACRO!B23,1,1,FALSE,"TEMPLATE"), I want the go to reference to change with each of 12 (or more) loops through the MACRO. e.g. the reference may be "TEMPLATE!R191C2" the next time etc.
Another way I can see to solve this is to be able to
have ActiveWorkbook.Names.Add Name:="pastedatestart", RefersToR1C1:= _
"=TEMPLATE!R18C2" so that the named range changes according to what is delivered by the ADDRESS function.
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden"><input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
Using Excel MACROS,
Application.Goto Reference:="TEMPLATE!R18C2"
where "TEMPLATE!R18C2" changes all the time and comes from a function =ADDRESS(MACRO!B23,1,1,FALSE,"TEMPLATE"), I want the go to reference to change with each of 12 (or more) loops through the MACRO. e.g. the reference may be "TEMPLATE!R191C2" the next time etc.
Another way I can see to solve this is to be able to
have ActiveWorkbook.Names.Add Name:="pastedatestart", RefersToR1C1:= _
"=TEMPLATE!R18C2" so that the named range changes according to what is delivered by the ADDRESS function.
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden"><input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
Last edited: