Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable Reference in R1C1 format
I would like to go back to the cell that was being used prior to running a macro. I have tried the following with no luck.
a = ActiveCell.Addres Range("A9").Selec Application.Goto Reference:= End Su It appears that the Application.Goto Reference statement wants the variable to be in R1C1 format. I can't figure out how to convert it to that format Any help would be appreciated Thank |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable Reference in R1C1 format
Try
Application.GoTo Reference:=Range(a) -- John Green - Excel MVP Sydney Australia "Ndel40" wrote in message ... I would like to go back to the cell that was being used prior to running a macro. I have tried the following with no luck. a = ActiveCell.Address Range("A9").Select Application.Goto Reference:=a End Sub It appears that the Application.Goto Reference statement wants the variable to be in R1C1 format. I can't figure out how to convert it to that format. Any help would be appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
R1C1 reference | Excel Discussion (Misc queries) | |||
R1C1 reference style | Excel Discussion (Misc queries) | |||
R1C1 reference style | Excel Discussion (Misc queries) | |||
R1C1 format using a variable? | Excel Discussion (Misc queries) | |||
R1C1 reference | Excel Discussion (Misc queries) |