Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut and Paste Macro
I am trying to create a Macro that cuts some preset text and pastes it
to the cell that I currently have selected. I created a button and linked it to a macro with the following code: Sub Macro1() Range("A1:C1").Select Range("C1").Activate Selection.Copy Range("A8").Select ActiveSheet.Paste End Sub The problem is that it always copies the code to cell A8. I see where like 5 does this, but I haven't been able to find the command which always puts it in the currently selected cell. Your help is appreciated. Price |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut and Paste Macro
This will do. Select the target cell, press the button.
Sub Macro1() Range("A1:C1").Copy ActiveSheet.Paste End Sub -----Original Message----- I am trying to create a Macro that cuts some preset text and pastes it to the cell that I currently have selected. I created a button and linked it to a macro with the following code: Sub Macro1() Range("A1:C1").Select Range("C1").Activate Selection.Copy Range("A8").Select ActiveSheet.Paste End Sub The problem is that it always copies the code to cell A8. I see where like 5 does this, but I haven't been able to find the command which always puts it in the currently selected cell. Your help is appreciated. Price . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run macro after paste | Excel Worksheet Functions | |||
Cut and Paste Macro | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Cut&Paste Macro | Excel Worksheet Functions |