mark active cell and return to paste
 

after macro is run

....i want to run another macro starting in the exact cell that the
previous code ended in.


mark active cell
Range("R4").Select
Selection.Copy
return to "active cell"
ActiveSheet.Paste

mark active cell and return to paste
 

No need to use select, it is just slowing down the code:

Range("R4").Copy ActiveCell

or the more descriptive one:
Range("R4").Copy Destination:=ActiveCell

Regards,
Per

"J.W. Aldridge" skrev i meddelelsen
...
after macro is run

...i want to run another macro starting in the exact cell that the
previous code ended in.


mark active cell
Range("R4").Select
Selection.Copy
return to "active cell"
ActiveSheet.Paste

mark active cell and return to paste
 

THANX!

mark active cell and return to paste
 

On Mar 1, 12:13*pm, "J.W. Aldridge"
wrote:
after macro is run

...i want to run another macro starting in the exact cell that the
previous code ended in.

mark active cell
* * Range("R4").Select
* * Selection.Copy
return to "active cell"
* * ActiveSheet.Paste

Unless I'm misreading, it sounds like you want to save the location of
the last active cell processed by Macro-A (for instance) to
<someplace so Macro-B can begin its own processing from that
location.

A public global variable would allow you to pass Macro-A's last active
cell location to Macro-B, however only if they run during the same
session -- otherwise the easiest way I can think of is for Macro-A to
save the location to an otherwise unused known location (ie: cell
IV65536) so Macro-B can assign it to its own variable when it begins
processing.