Returning Macro to Starting Cell
Option explicit
sub test()
Dim ActCell as range
set actcell = activecell
'do your stuff
application.goto actcell
end sub
sony654 wrote:
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
--
Sony Luvy
--
Dave Peterson
|