View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James Cooper James Cooper is offline
external usenet poster
 
Posts: 5
Default Put worksheet names into worksheet Excel 2000?

Hello,

The following code gives me this error "Run-time error '9': Subscript out of
range.

What I would like to do is put 25 of the 30 worksheet names from one
workbook into the same workbook on a worksheet but this is my problem I do
not want worksheet 1-5 included.

How can the following code be modified to put 25 of the 30 worksheet names
on one worksheet in the same workbook.

Thank you for you help,
James Cooper