Last Used Column in Loop Data Copy

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.