Basic question.... please answer

Posted by Jonnie on January 09, 2002 7:50 AM

Hi...
What I need is that, after executing a big macro the window go back to the ActiveCell before the macro executed.... Something like this...

Row = Selection.Offset(0, 0).Row
Column = Selection.Offset(0, 0).Column

**** HERE COMES THE BIG MACRO *****

Now it should go back to
Range(Column & Row).Select
This code doesnt work... What should I put here instead??
Thank you!

Posted by Juan Pablo G. on January 09, 2002 7:58 AM

First, don't use Offset, just use

Row = Selection.Row
Column = Selection.Column

then, at the end just use

Cells(Row,Column).Select

Juan Pablo G.

Posted by Tom Dickinson on January 09, 2002 10:30 AM

Start w/ "String = activecell.addresslocal" & Range(String).Select (NT)