Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In Excel 2007 I have the very simple code (abridged for clarity):
Private Sub cmdRefreshRMTable_Click() With Workbooks("RM_Master.xls").Worksheets("ESC_RM_Cost ") .QueryTables(1).Refresh BackgroundQuery:=False End With End Sub that gives me a subscript out of range error on the refresh method. The workbook name is spelled correctly, the worksheet name is spelled correctly and there is only one query table in the entire workbook. In Excel 2003 this same code works properly. What am I missing? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
error 9 subscript out of range | Excel Programming | |||
Runtime Error - Subscript out of range despite On Error statement | Excel Programming | |||
Subscript out of range error - save copy error | Excel Programming | |||
Subscript out of range error - save copy error | Excel Programming | |||
Type Mismatch error & subscript out of range error | Excel Programming |