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