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
|