I want to copy a whole worksheet from a workbook that is not active into an active workbook, but i'm getting the error "subscript out of range" This is what i've done....any suggestions?
Workbooks("c:timesheetsexpenditureconsulting_tues.xls").Sheets(1).Copy _
after:=ActiveWorkbook.Sheets(2)
Workbooks("c:timesheetsexpenditureconsulting_tues.xls").Sheets(1).Copy _
after:=ActiveWorkbook.Sheets(2)