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

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

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