macro coding for a copy and paste

[Toaster-Roaster]

im tring to create a macro button which pastes my selected copied section to a certain column. once one has been pasted it will then paste to the row below e.t.c

 

[tigeravatar]

Toaster-Roaster,

Something like this?

Sub Button1_Click()
    
    Const DestCol As String = "A"
    Selection.Copy Cells(Rows.Count, DestCol).End(xlUp).Offset(1, 0)
    
End Sub

Hope that helps,
~tigeravatar

 

[Toaster-Roaster]

this didnt work unfortunately, this section had an error to do with the wrong number of arguments or invalid property assignment "Selection.Copy Cells(Rows.Count, DestCol).End(xlUp).Offset(1, 0)"


i was going to use it so i can reference things easily and copy a website link and then paste each link under the other in column e from row 3

 

[tigeravatar]

The code runs fine for me with no error

 

[Toaster-Roaster]

no i still have a problem, could you try a different code?