Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning Macro to Starting Cell
PROBLEM: 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 I appreciate the responses below, but I do not comprehend. I use macro recorder to create all my macros. When macro recording, what do I do with Activecell? Some responses tell me to send the value to Activecell Option explicit sub test() Dim ActCell as range set actcell = activecell 'do your stuff application.goto actcell end sub -- -- Sony Luvy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting macro to copy to starting cell | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Macro help - copy a cell down | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |