Urgent - How do i select a range of pages with a defined name?

[gareth001]

Hi,

I've got a list of pages i want to select using VB, the list of pages is contained within a defined name ("PageSelector"). When i use this defined name to select one sheet - eg.

   Dim PageSelect As String

   PageSelect = Evaluate("PageSelector")

   Sheets(PageSelect).Select

The code works with no problem, but as soon as i try and use multiple pages with

Sheets(Array(PageSelect)).Select

Nothing will work, the code just skips past this section. I've tried all types of ways of storing the page names, currently they are stored in excel as: "Pg1", "Pg2", etc.

Thank you very much for your help, I've been trying all everning to get this working.

 

[BobRodes]

Perhaps you'll want to try the Microsoft Office forum.

HTH

Bob