View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Axanamoon Axanamoon is offline
external usenet poster
 
Posts: 4
Default One button, Multi Cells

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.