got a slight problem pasting info from 1 sheet to a specific place on another sheet.
heres what i tried (which doesnt work!)
Sub Macro1()
Dim endcell As Integer
Dim endcell2 As Integer
Sheet1.Select
endcell = Range("A1").End(xlDown).Row
Range("A1:B" & endcell).Select
Selection.Copy' copys just the 2 colums of info
Sheet3.Select
endcell2 = Range("A1").End(xlDown).Row
endcell2 = endcell2 + 1
newcell = endcell + endcell2
ActiveSheet.Paste Destination:=Worksheets("Sheet3").Range("A & endcell2 :B & newcell")
tried to copy in the information into sheet3, (sheet3 already contains info). Have no problem doing it when no info is in sheet3, but have probs when there is already info in.
pls can anyone help?
thanks
End Sub
Bookmarks