slang
04-01-2008, 06:53 AM
I have a small module that opens a file on a shared network drive and copys information back to the sheet. This works with some users but some get a runtime error#9, subscript out of range when the "Windows("TADS 1.2.xls").Activate line is ran in the code below.
I know I am missing something but I am new to this.Thanks in advance on any help you could provide.
I am using Excel 2003 sp2 and the workbook with the code is TADS 1.2.xls
Thanks....
Workbooks.Open filename:= _
"I:\BDMSFA\BDMdatafiles\tombstonecrm.xls"
Cells.Select
Selection.AutoFilter
Selection.AutoFilter Field:=16, Criteria1:=terrnum
rows("2:4000").Select
Selection.copy
Windows("TADS 1.2.xls").Activate
Range("A2").Select
I know I am missing something but I am new to this.Thanks in advance on any help you could provide.
I am using Excel 2003 sp2 and the workbook with the code is TADS 1.2.xls
Thanks....
Workbooks.Open filename:= _
"I:\BDMSFA\BDMdatafiles\tombstonecrm.xls"
Cells.Select
Selection.AutoFilter
Selection.AutoFilter Field:=16, Criteria1:=terrnum
rows("2:4000").Select
Selection.copy
Windows("TADS 1.2.xls").Activate
Range("A2").Select