paste value column based on first cell command button

[Norvascom]

Hi,
I have a spreadsheet with several columns each with 10 rows of data. I
would like to have a code to copy/paste value on rows 2 to 11 when a
command button located on the first row (row 1) is activated. Command
buttons would be on the first cell of each column but only the row for
which the command button is pushed would have its values pasted.
Thanks

 

[Don Guillett Excel MVP]

Hi,
I have a spreadsheet with several columns each with 10 rows of data. I
would like to have a code to copy/paste value on rows 2 to 11 when a
command button located on the first row (row 1) is activated. Command
buttons would be on the first cell of each column but only the row for
which the command button is pushed would have its values pasted.
Thanks

I don't fully understand what you want but you do NOT need a command
button for each column. You could use a double_click event macro for
the ACTIVECELL.COLUMN.
"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."