Worksheet names 2

[Phil]

Do the worsksheets have a fixed identifier in addition to it's worksheet
name. ie/ is the first worksheet always 1 etc. If so, how can you identify
the worksheet in this way.

[Bob Phillips]

The worksheet has an index number, which start at 1 for the first sheet, 2
for the second, and changes if you move the sheets.

But better yet, they have a codename, which you can change in the VBIDE, and
which doesn't change as sheets move, or as a user renames the Excel name.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Phil" <Phil@discussions.microsoft.com> wrote in message
news:62539AF4-8CC3-4198-8AB1-6A6797032AD1@microsoft.com...
> Do the worsksheets have a fixed identifier in addition to it's worksheet
> name. ie/ is the first worksheet always 1 etc. If so, how can you
identify
> the worksheet in this way.

[Phil]

How do you include the index number in a formula, if you wanted to link to a
cell in worksheet one for example.

VBIDE is new to me. Is there anywhere I can go for more information in this.

"Bob Phillips" wrote:

> The worksheet has an index number, which start at 1 for the first sheet, 2
> for the second, and changes if you move the sheets.
>
> But better yet, they have a codename, which you can change in the VBIDE, and
> which doesn't change as sheets move, or as a user renames the Excel name.
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Phil" <Phil@discussions.microsoft.com> wrote in message
> news:62539AF4-8CC3-4198-8AB1-6A6797032AD1@microsoft.com...
> > Do the worsksheets have a fixed identifier in addition to it's worksheet
> > name. ie/ is the first worksheet always 1 etc. If so, how can you
> identify
> > the worksheet in this way.
>
>
>

[Bob Phillips]

Phil,

We are talking VBA here, I don't know if you realised this?

The VBIDE is accessed via Alt-F11, where you get access to VBA, macros, et
al. When in the VBIDE, you have a explorer that shows all objects
(worksheets, code modules, etc.) in that project (workbook). You also have a
properties window, where you can change the codename.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Phil" <Phil@discussions.microsoft.com> wrote in message
news:1E5A3F1B-950B-4DF5-B3CA-8DDD859BFFB7@microsoft.com...
> How do you include the index number in a formula, if you wanted to link to
a
> cell in worksheet one for example.
>
> VBIDE is new to me. Is there anywhere I can go for more information in
this.
>
> "Bob Phillips" wrote:
>
> > The worksheet has an index number, which start at 1 for the first sheet,
2
> > for the second, and changes if you move the sheets.
> >
> > But better yet, they have a codename, which you can change in the VBIDE,
and
> > which doesn't change as sheets move, or as a user renames the Excel
name.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (replace somewhere in email address with gmail if mailing direct)
> >
> > "Phil" <Phil@discussions.microsoft.com> wrote in message
> > news:62539AF4-8CC3-4198-8AB1-6A6797032AD1@microsoft.com...
> > > Do the worsksheets have a fixed identifier in addition to it's
worksheet
> > > name. ie/ is the first worksheet always 1 etc. If so, how can you
> > identify
> > > the worksheet in this way.
> >
> >
> >

[Phil]

Thanks

How do I identify the index number (which changes as you move the sheets) to
use it in a formula

"Bob Phillips" wrote:

> Phil,
>
> We are talking VBA here, I don't know if you realised this?
>
> The VBIDE is accessed via Alt-F11, where you get access to VBA, macros, et
> al. When in the VBIDE, you have a explorer that shows all objects
> (worksheets, code modules, etc.) in that project (workbook). You also have a
> properties window, where you can change the codename.
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Phil" <Phil@discussions.microsoft.com> wrote in message
> news:1E5A3F1B-950B-4DF5-B3CA-8DDD859BFFB7@microsoft.com...
> > How do you include the index number in a formula, if you wanted to link to
> a
> > cell in worksheet one for example.
> >
> > VBIDE is new to me. Is there anywhere I can go for more information in
> this.
> >
> > "Bob Phillips" wrote:
> >
> > > The worksheet has an index number, which start at 1 for the first sheet,
> 2
> > > for the second, and changes if you move the sheets.
> > >
> > > But better yet, they have a codename, which you can change in the VBIDE,
> and
> > > which doesn't change as sheets move, or as a user renames the Excel
> name.
> > >
> > > --
> > > HTH
> > >
> > > Bob Phillips
> > >
> > > (replace somewhere in email address with gmail if mailing direct)
> > >
> > > "Phil" <Phil@discussions.microsoft.com> wrote in message
> > > news:62539AF4-8CC3-4198-8AB1-6A6797032AD1@microsoft.com...
> > > > Do the worsksheets have a fixed identifier in addition to it's
> worksheet
> > > > name. ie/ is the first worksheet always 1 etc. If so, how can you
> > > identify
> > > > the worksheet in this way.
> > >
> > >
> > >
>
>
>

[Bob Phillips]

The first sheet is always 1. If you have the name then you can use

Worksheets("mySheet").Index

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Phil" <Phil@discussions.microsoft.com> wrote in message
news:9C0F7C4B-1F0D-463C-A458-1BC032C8EEB8@microsoft.com...
> Thanks
>
> How do I identify the index number (which changes as you move the sheets)
to
> use it in a formula
>
> "Bob Phillips" wrote:
>
> > Phil,
> >
> > We are talking VBA here, I don't know if you realised this?
> >
> > The VBIDE is accessed via Alt-F11, where you get access to VBA, macros,
et
> > al. When in the VBIDE, you have a explorer that shows all objects
> > (worksheets, code modules, etc.) in that project (workbook). You also
have a
> > properties window, where you can change the codename.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (replace somewhere in email address with gmail if mailing direct)
> >
> > "Phil" <Phil@discussions.microsoft.com> wrote in message
> > news:1E5A3F1B-950B-4DF5-B3CA-8DDD859BFFB7@microsoft.com...
> > > How do you include the index number in a formula, if you wanted to
link to
> > a
> > > cell in worksheet one for example.
> > >
> > > VBIDE is new to me. Is there anywhere I can go for more information in
> > this.
> > >
> > > "Bob Phillips" wrote:
> > >
> > > > The worksheet has an index number, which start at 1 for the first
sheet,
> > 2
> > > > for the second, and changes if you move the sheets.
> > > >
> > > > But better yet, they have a codename, which you can change in the
VBIDE,
> > and
> > > > which doesn't change as sheets move, or as a user renames the Excel
> > name.
> > > >
> > > > --
> > > > HTH
> > > >
> > > > Bob Phillips
> > > >
> > > > (replace somewhere in email address with gmail if mailing direct)
> > > >
> > > > "Phil" <Phil@discussions.microsoft.com> wrote in message
> > > > news:62539AF4-8CC3-4198-8AB1-6A6797032AD1@microsoft.com...
> > > > > Do the worsksheets have a fixed identifier in addition to it's
> > worksheet
> > > > > name. ie/ is the first worksheet always 1 etc. If so, how can you
> > > > identify
> > > > > the worksheet in this way.
> > > >
> > > >
> > > >
> >
> >
> >