Copy and Paste as Values using Command Button

**macky1730** · 03-08-2011, 03:39 PM

Hello, how to make a code for copying from a specific cell and paste it in other cell as values.

my cells to copy are fixed ( K1,L1,K2,L2 )
my cells to be pasted as values ( A1,B1,C1,D1 )

after executing the command button, values from ( K1,L1,K2,L2 ) will automatically paste in ( A1,B1,C1,D1 ) After changing the values again in ( K1,L1,K2,L2 ) and executing the button the values will be in (A2,B2,C2,D2). and if repeated click of button it will fill downwards.

Thanks in advance

**MarvinP** · 03-08-2011, 03:51 PM

Hi,
Find the attached with code.

Please Login or Register  to view this content.

**macky1730** · 03-08-2011, 03:56 PM

yey! thanks, simple code and editable. i can add my own and modify it for my convinience in the future

. rep added

**MarvinP** · 03-08-2011, 04:41 PM

If you wanted to copy to a different sheet try this code:

Please Login or Register  to view this content.

Watch out for those darn periods.

**macky1730** · 03-08-2011, 08:32 PM

thanks again, now im pretty sure it was an Aprove comment in your reputation

**Amoursi** · 10-04-2013, 01:50 AM

but how to start pasting from cell A5 for exaample

**Fotis1991** · 10-04-2013, 02:18 AM

@ Amoursi

Welcome to the forum.

Unfortunately you have to start a new thread for this,

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.