Runtime Error 9 Subscript Outta Range
wbkData.Activate
Tim
"David" wrote in message
...
This is driving me NUTS! This code works just fine in other workbooks, but
something is wrong here. I am getting the error on the last line of code.
Same error when trying to activate the wbkSum workbook too.
Here is the code:
Dim wbkSum As Workbook
Dim wbkData As Workbook
Dim iOffice As Integer
Set wbkSum = Workbooks("My DMR Summary May 2007.xls")
Set wbkData = ActiveWorkbook
Windows("wbkData").Activate
|