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

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