sheets("sourcesheet").range("a2:x200").copy
sheets("destinationsheet").range("a1")

--
Don Guillett
SalesAid Software

" wrote
in message ...
I am making an excel spreadsheet and I want to create a command button on
the
sheet itself to where a user can go to another area, copy materal, come
back
to the worksheet and click on the command button to paste information onto
the sheet to a specific cell without using keyboard shortcuts or the
mouse..
Is this possible and how?