View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default go to sheet number

You can access a sheet by its position number. E.g.,

Sheets(10).Activate


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"John" wrote in message
...
Errors are given in sheet numbers but the sheets have names not
numbers.

How do you "go to" a sheet number? I have about 200 in a
workbook.

Thanks
John