variable copy past area in vba

[solo_razor]

hi,

I have a problem concerning a variable copy past area. I want to copy a
certain area that contains value's and then copy it into another
worksheet: e.g.

Part Number Type number
1232321 231321
4564654 54654564
54656645 56465456

copy values from under part number to
new workbook also under a header

Number Part Typing number


thanks

 

[Tom Ogilvy]

Range("A1:A500").copy Destination:=Worksheets("Sheet2").Range("Z10")