View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Using Macro, want to group all Worksheets, but Sheet1,How?

try
Sheets(1).Select

--
Don Guillett
SalesAid Software

"Dandelo" wrote in message
...
I want to use the code name to reference Sheet1, the Sheet is named
something
else and the name will continue to change.

Also, the first line keeps failing with ,<type mismatch:

Sheets(Sheet1).Select
--
Thank you so much for your help!