Posted to microsoft.public.excel.programming

Ndel40[_2_] Ndel40[_2_] is offline

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
R1C1 reference	Rick	Excel Discussion (Misc queries)	4	March 26th 10 11:24 PM
R1C1 reference style	Helpme Please[_2_]	Excel Discussion (Misc queries)	5	July 11th 07 11:12 PM
R1C1 reference style	Peg P	Excel Discussion (Misc queries)	2	November 15th 05 06:48 PM
R1C1 format using a variable?	jim37055	Excel Discussion (Misc queries)	3	October 4th 05 05:47 PM
R1C1 reference	Tony S	Excel Discussion (Misc queries)	1	May 10th 05 05:58 PM

All times are GMT +1. The time now is 06:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us