Can you be a bit more specific on where you want to paste them on Sheet2?
What column/s do you want them in? You have specified cells a3, b5, c8 and
b11 to copy. 2 of these are in column B so I am assuming you don't want them
in the corresponding columns on Sheet2. Perhaps you want them one under the
other in the same column; but which column?

--
Regards,

OssieMac


"Axanamoon" wrote:

I'm somewhat new to VBA and I sure could use some help. I'm trying to put a
command button in Excel (2003) on sheet1 that when clicked will select 4
certain cells (a3, b5, c8 and b11) and paste them onto the next blank row on
sheet2 in that order. Can this be done without setting up 4 different
buttons? Any help anyone could give would be so appreciated. Thanks.