Workbooks("Mappe1").Activate trouble

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
gee. didnt think bout that, but that did it fine
thanks Dave


"Dave Peterson" skrev:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vb?.tmp path/file access error 2
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
Run code from another workbook 7
All Workbook Saved except This Workbook - Part2 3
Problem Closing Sheet 4
Access an open workbook without making it active 2
Run macro from active workbook whose name keeps changing 20
Select range from unopened workbook 7

Back
Top