Returning Macro to Starting Cell

[Guest]

How do I run a macro and always have the result return to the starting cell.
Meaning, if the cursor is in cell d3 when I launch the macro, I want the last
step of the macro to return to d3. Then the next time I run it, it starts in
e3 and returns to e3. Thanks for your help. Sony

 

[Bob Phillips]

Send the value to ACtivecell.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Guest]

Bob - please clarify, how do I send to the ACtivecell? What does that mean?
Thanks

 

[Dave Peterson]

Option explicit
sub test()
Dim ActCell as range

set actcell = activecell

'do your stuff

application.goto actcell

end sub

 

[Bob Phillips]

Save the activecell like this

Set startCell = Activecell

then at the end of the macro, select it

startCell.Select

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)