Last Used Column in Loop Data Copy

**gsurge** · 05-31-2011, 11:49 AM

Hello,

Can someone please help me adjust the following code to pull data from the Last Used Column in the source workbooks, thus replacing the "B" column designation? I do not want the code to require adjusting the column value, and instead, simply search for the last column with data on the source workbook to copy to the destination workbook.

Thanks

Please Login or Register  to view this content.

**Leith Ross** · 05-31-2011, 12:15 PM

Hello gsurge,

Here is the corrected macro...

Please Login or Register  to view this content.

**gsurge** · 05-31-2011, 12:23 PM

Thank you so much Leith!

Just so I can understand the added code better, can you briefly explain the syntax you entered to determine LastCol?

**Leith Ross** · 05-31-2011, 12:33 PM

Hello gsurge,

The code used to find the last column searches the worksheet cells column by column starting with the last column and moving left until it finds a cell in a column or it returns back to cell "A1". The "*" is a wildcard meaning any value in the cell.

By checking if the result is "Nothing", the decision is made to either extract the column of the last cell or skip to the next workbook. If the resulting Range object isn't check to be "Nothing", a error will occur.