ExcelBanter - Workbooks("Mappe1").Activate trouble

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Workbooks("Mappe1").Activate trouble (https://www.excelbanter.com/excel-programming/392835-workbooks-mappe1-activate-trouble.html)

excelent

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

Dave Peterson

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

excelent

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

All times are GMT +1. The time now is 03:43 PM.