View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default 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