View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Felix[_3_] Felix[_3_] is offline
external usenet poster
 
Posts: 5
Default 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
.