cccontract
06-23-2015, 06:43 PM
I am trying to find the seven columns that come before the last column.
I find the last column using: (ws.Range("A65536").End(xltoright).Column).
I would like to then take this range of the seven last columns and paste it into another workbook.
I have tried using offset but I'm pretty new and can't seem to get it to work.
I find the last column using: (ws.Range("A65536").End(xltoright).Column).
I would like to then take this range of the seven last columns and paste it into another workbook.
I have tried using offset but I'm pretty new and can't seem to get it to work.