| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbooks("Mappe1").Activate trouble
When i run this code i got a error...
Run-time error 9 Subscript out of range. Why ? Sub Focus() Workbooks("Mappe1").Activate End Sub Im trying to activate book "Mappe1" from book "Mappe3" - both are open! Using Windows Vista Excel 2003 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbooks("Mappe1").Activate trouble
Include the extension:
workbooks("mappe1.xls").activate excelent wrote: When i run this code i got a error... Run-time error 9 Subscript out of range. Why ? Sub Focus() Workbooks("Mappe1").Activate End Sub Im trying to activate book "Mappe1" from book "Mappe3" - both are open! Using Windows Vista Excel 2003 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbooks("Mappe1").Activate trouble
gee. didnt think bout that, but that did it fine
thanks Dave "Dave Peterson" skrev: Include the extension: workbooks("mappe1.xls").activate excelent wrote: When i run this code i got a error... Run-time error 9 Subscript out of range. Why ? Sub Focus() Workbooks("Mappe1").Activate End Sub Im trying to activate book "Mappe1" from book "Mappe3" - both are open! Using Windows Vista Excel 2003 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
| problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
| "Select" and "Activate" failing? | Excel Programming | |||
| use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
| "Subscript out of range" error for: Workbooks("Test1.xls").Save | Excel Programming | |||
Hybrid Mode
