stephen antoine
Board Regular
- Joined
- Jun 4, 2008
- Messages
- 128
Hello all,
For some reason the code below gets an error saying the subscript is out of range once it gets to the last step...
Does anyone know why the error is popping up when the sub tries to close the workbook?
For some reason the code below gets an error saying the subscript is out of range once it gets to the last step...
Code:
CM_Current_Payments_Export = "J:\Utilities\Building Rent\FY2008\Rent Reconciliation\05 - Jun\Export_Current_Payments_Active_Jun-2008.xls"
Workbooks.Open Filename:= _
CM_Current_Payments_Export
Cells.Copy
Windows(CM_PP_Rec).Activate
Sheets("Current_Payments").Paste
Workbooks(CM_Current_Payments_Export).Close savechanges:=False
Does anyone know why the error is popping up when the sub tries to close the workbook?