Need to Copy Columns from Previous Workbook to Newly Opened Workbook

I use a macro to open the latest workbook in a folder; the code is listed below. I need to copy all of columns B:N in my original workbook and paste them into the newly opened workbook columns C:O. I've tried a few things but I keep getting "subscript out of range" errors. Do I need to set the new workbook to the active workbook? I'm puzzled.

Please Login or Register  to view this content.

Moderator's Edit: Use code tags when posting code. To do so in future, select your code and click on the # icon at the top of your post window.

Which line does it highlight when you get the error?

Originally Posted by arlu1201

Which line does it highlight when you get the error?

It doesn't highlight any line or cell; the "waiting" cursor comes up until I close out the error box. I must be using the wrong code to copy the columns. The newly opened sheet automatically has the first sheet titled "Breakdown", and my original workbook has a sheet1 titled Sheet1, so I used the following code: Probably wrong.

Please Login or Register  to view this content.

Before running the macro, is the latest file already open? Or should the macro open the file?

Try this -

Please Login or Register  to view this content.

It copies data from the original workbook which contains the macro to the file you open. It will copy the entire columns. If you need only the rows to be copied without the header, let me know. You need to tweak the code a little for that.