As always, post your macro for comments and suggestions.

--
Don Guillett
SalesAid Software

"RocketRod" wrote in message
...
I have a spreadsheet with "Sheet 1" and "Sheet 2"
Both have some data
I want a command button on Sheet 1 with code that will copy & move some
data
on Sheet 1 elsewhere on Sheet 1, then on Sheet 2 copy & move some other
data
on Sheet 2 elsewhere on Sheet 2 then return active cell to Sheet 1
If I record a macro and run it it works perfectly
If I copy that code into the Command Button code it has an error when it
selects the data on Sheet 2