Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
mark active cell and return to paste
THANX!
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return to active cell after sort | Excel Programming | |||
Mark active row in column A (VB question) | Excel Discussion (Misc queries) | |||
How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
Return to active cell | Excel Discussion (Misc queries) | |||
Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming |