Using Macro, want to group all Worksheets, but Sheet1,How?

[Dandelo]

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!

[Don Guillett]

try
Sheets(1).Select

--
Don Guillett
SalesAid Software
[email protected]
"Dandelo" <[email protected]> wrote in message
news:[email protected]...
>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!

[Dandelo]

Wow!, thank you, Don. that did it!
--
Thank you so much for your help!


"Don Guillett" wrote:

> try
> Sheets(1).Select
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Dandelo" <[email protected]> wrote in message
> news:[email protected]...
> >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!
>
>
>

[Don Guillett]

glad to help

--
Don Guillett
SalesAid Software
[email protected]
"Dandelo" <[email protected]> wrote in message
news:[email protected]...
> Wow!, thank you, Don. that did it!
> --
> Thank you so much for your help!
>
>
> "Don Guillett" wrote:
>
>> try
>> Sheets(1).Select
>>
>> --
>> Don Guillett
>> SalesAid Software
>> [email protected]
>> "Dandelo" <[email protected]> wrote in message
>> news:[email protected]...
>> >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!
>>
>>
>>