pasting form 1 sheet to another
 

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


--
s_ali_hassan
------------------------------------------------------------------------
s_ali_hassan's Profile: http://www.excelforum.com/member.php...o&userid=35325
View this thread: http://www.excelforum.com/showthread...hreadid=552200

pasting form 1 sheet to another
 

wups, worked it out myself!
wrong speechmarks


--
s_ali_hassan
------------------------------------------------------------------------
s_ali_hassan's Profile: http://www.excelforum.com/member.php...o&userid=35325
View this thread: http://www.excelforum.com/showthread...hreadid=552200