copy method of range class failed. WHY??

[Esviel]

All I want to do is copy two columns from one workbook to another. Here's the line that's giving me trouble:

Workbooks(File_String).Worksheets("current_product_mgr_res_nophone").Columns("A:B").Copy Workbooks("Resume_Test_Final_Revisedv3.xlsm").Worksheets("Prod_Mgr_Res_NoPhone").Cells(4, col)

It says "copy method of range class failed". why can't I copy/paste??

 

[AlphaFrog]

You are copying .Columns("A:B") and trying to paste the two whole columns starting at row 4 .Cells(4, col)

The last 4 rows of the two columns would run off the sheet. That's causing the error.

Maybe try something like this.

Workbooks(File_String).Worksheets("current_product_mgr_res_nophone").[COLOR="Red"]Range("A1:B" & Rows.Count - 4)[/COLOR].Copy Workbooks("Resume_Test_Final_Revisedv3.xlsm").Worksheets("Prod_Mgr_Res_NoPhone").Cells(4, col)

 

[Esviel]

thank you SOO MUCH. that is extremely helpful.

As you can probably tell, I am VERY new to vba programming so I'm just recently learning all of the ins and outs. After hours of google searching I learned about the currentregion method, which allowed me to select those two columns regardless of how many rows were populated (because I was copying from a bunch of different sheets each with different numbers of rows, which is why I initially just copied the whole column). I was suspicious that copying the entire columns was the problem and now you've confirmed that.