pasting form 1 sheet to another

  • Thread starter Thread starter s_ali_hassan
  • Start date Start date
S

s_ali_hassan

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create Detail Sheets from Pivot Table 1
Count Duplicates 8
Macro running within Macro 2
Auto fill Sheets 1
Is there something faster than select case? 9
My Never ending ARRAY code problems 18
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Filter and copy data to other sheet 3

Back
Top