Variable Reference in R1C1 format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help with dates in the past 5
input numbers for code 3
setting more than one filter 1
Selecting Range of Copied Text 2
filtering two pieces of data 3
"Runtime error 1004 Application-defined or object defined error" on data sort 0
Macro to Paste at next blank row 3
macro help 2

Back
Top