Generic Workbook Select

[Michael]

Hi! This is a really easy one, but I can't seem to find
the answer. I was wondering what the code is to
generically activate the other open workbook in Excel
without naming it proper. Something like this (but not
this obviously):

Workbooks.Next.Select

Thanks!

Sincerely,

Michael

 

[Bob Phillips]

Hi Michael,

Here is one way

Dim wb
For Each wb In Workbooks
If wb.Name <> ActiveWorkbook.Name Then
wb.Activate
End If
Next wb

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[DM]

Activewindow.Activatenext

DR. M