headings in copy and paste

[RoseChapman]

Hello


I am trying to copy what I have in column H of Sheet 1 and paste the same column in columns B and D of sheet 2. The problem I am having is that I am also copying the headings from sheet 1 in sheet 2 and I do not want that, I do not know how to avoid the headings, could you please help?

Worksheets("sheet1").Range("H:H").Copy


Worksheets("sheet2").Range("B:B, D;D").PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False

Thanks
Rose

 

[DanteAmor]

Try this
Change the 2 to the row where your data begins.

Sheets("sheet1").Range("H[COLOR=#ff0000]2[/COLOR]:H" & Sheets("sheet1").Range("H" & Rows.Count).End(xlUp).Row).Copy
Sheets("sheet2").Range("B[COLOR=#ff0000]2[/COLOR], D[COLOR=#ff0000]2[/COLOR]").PasteSpecial Paste:=xlPasteValues

 

[Fluff]

How about

Worksheets("sheet1").Range("H2:H" & Rows.Count).Copy


Worksheets("sheet2").Range("B2, D2").PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False

 

[RoseChapman]

This is great!, it works!! i really appreciate your help, thank you ever so much!!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.

 

[RoseChapman]

Thanks to you always

 

[DanteAmor]

 

[Fluff]

I'm glad to help you. Thanks for the feedback.

What he said

 

[RoseChapman]