Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste value column based on first cell command button
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste value column based on first cell command button
On Oct 29, 12:40*pm, Norvascom wrote:
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." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
based on Cell/Column content ,cut one sheet's values and paste it in other sheet? | Excel Programming | |||
based on Cell/Column content ,cut one sheet's values and paste it in other sheet? | Excel Programming | |||
How do I add a command button on a worksheet to "paste" from the . | Excel Worksheet Functions | |||
How do I add a command button on a worksheet to "paste" from the . | Excel Worksheet Functions | |||
copy & paste command button | Excel Programming |