Copy column from Workbook1 to Workbook2 but starting from specific cell: Cant fix error

[eddthebed]

Hi,

as the title says what I need is to copy a column from one workbook to another but I need to paste that column starting from specific cell. E.g copy contents of A1:A10 of workbook1 sheet1 to B3:B13 in workbook2 sheet2. Here is the code but is giving me 'Subscript out of range' error:

Please Login or Register  to view this content.

[Vidya Palani]

Try this.. You can replace xlPasteValues by xlPasteFormulas if the column contains formulas.

Please Login or Register  to view this content.

[Vidya Palani]

Try this.. You can replace xlPasteValues by xlPasteFormulas if the column contains formulas.

Please Login or Register  to view this content.

[eddthebed]

It works now. Thanks!