View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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