I want to copy a range of cells from one sheet to another using either an activeX or VBA control button. I'm stuck on the syntax for the pasting destination. Thanks for any help.