View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nelly nelly is offline
external usenet poster
 
Posts: 31
Default Help Selecting Sheets Array form a list box

Hi All

I am having trouble and tried many things but just can't work it out!

I have a list box that contains the names of 25 sheets in a worksbook that
contains 27 sheets. What I need is the code so that when you select a few
sheet names from the list box these sheets are selected and copied to a new
workbook.

I can get the sheet names into a string but cannot use that in an array!!!

Many Thanks in advance
Nelly