Doh ! The code is in the worksheet module. Of course. Thanks.

The code CAN to a certain degree deal with remote ranges if properly
addressed. But it shouldn't, so I second your advice.

Best wishes Harald

"Mike Fogleman" <mikefogleman@insightbb.com> skrev i melding
news:%23uOW4vJUFHA.3188@TK2MSFTNGP09.phx.gbl...
> Jonathon, generally speaking a CommandButton_Click event code can only
deal
> with ranges on the same sheet as the button. In your case, with the button
> on Sheet2, but wanting to involve ranges on Sheet1, put your macro code in
a
> general module and Call it from the CommandButton_Click event. Also, heed
> Harold's advice about selecting objects. His code, in a general module,
will
> put the value on Sheet1 as you wanted. Only do a Copy/Paste if you need
the
> cell formatting also transfered.
>
> Mike F