Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro changes sheet location
I have recorded a revaltively simple macro that, mostly copies and pastes
some data. After the Macro runs, the worksheet jump to a different location in the worksheet than where my Macro Button is located. Is there a way to tell the Macro to return to my original location or is there a way to configure the wroksheet so that it does not jump to the other location. Thank you very much for any assistance. Alan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro changes sheet location
Change A1 to what you want
Range("A1").Select "alanmart" wrote: I have recorded a revaltively simple macro that, mostly copies and pastes some data. After the Macro runs, the worksheet jump to a different location in the worksheet than where my Macro Button is located. Is there a way to tell the Macro to return to my original location or is there a way to configure the wroksheet so that it does not jump to the other location. Thank you very much for any assistance. Alan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro changes sheet location
Post your code... Since you recorded the macro it will be full of select and
activate statements which you do not need. We can help you to clean it up... -- HTH... Jim Thomlinson "alanmart" wrote: I have recorded a revaltively simple macro that, mostly copies and pastes some data. After the Macro runs, the worksheet jump to a different location in the worksheet than where my Macro Button is located. Is there a way to tell the Macro to return to my original location or is there a way to configure the wroksheet so that it does not jump to the other location. Thank you very much for any assistance. Alan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock location of sheet within a spreadsheet | Excel Discussion (Misc queries) | |||
location bar display in excel sheet | Excel Discussion (Misc queries) | |||
Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
Jumping to a location in an excel sheet. | Excel Programming | |||
saving w/sheet to different location | Excel Programming |