Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I get a run-time error '9': Subscript out of range.
Code: ActiveWindow.DisplayWorkbookTabs = True Sheets("UNIT BREAKOUT DATA").Visible = True Sheets("UNIT BREAKOUT DATA").Select Sheets("UNIT BREAKOUT DATA").Move Befo=Sheets(1) ActiveWindow.ScrollWorkbookTabs Position:=xlLast ****Sheets(Array("FFD", "PEND", "COVER", "PROFILE SUMMARY CHART (WING)", _ "NOT RECONCILED RATE {BY MONTH}", "WING PROFILES BY MONTH", "MIL Due Overdue", "CIV Due Overdue", _ "IMR Red", "HELP", "AF 422", "Compliance", "FFD", "ABBREV", "UsageLog", "PEND", "READINESS TYPES", _ "IMMUNIZATIONS", "DEMOGRAPHICS-AF 422", _ "4T Profile", "INTRO", "MR DATA")).Select********** ActiveWindow.SelectedSheets.Visible = False Sheets("UNIT BREAKOUT DATA").Activate Debug is highlighting the code between ********** ********** This code was working fine, but just blowup. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming | |||
Run-time error '11' & Run-time error '1004' | Excel Programming |