Refer to Excel Worksheet by its name

[RichB]

Is it possible, using the tools available in Excel 2002, to refer to a
worksheet by its name?

[swatsp0p]

In what way do you want to refer to a workbook by it's name?

If you mean in a formula referencing a specific cell or range in another open workbook, yes, you can. It would something like this:

='Test Workbook.xls'!$A$1

If the workbook has multiple sheets, it would look like:

='[Test Workbook.xls]Sheet2'!$A$1

If the workbook was closed, it would look like this:

='C:\Documents and Settings\My Documents\Excel\[Test Workbook.xls]Sheet2'!$A$1

If you meant something else, please provide more details.

HTH

[JE McGimpsey]

You mean something like

='My Sheet'!A1 + 'Sheet 2'!B1

???

In article <[email protected]>,
"RichB" <[email protected]> wrote:

> Is it possible, using the tools available in Excel 2002, to refer to a
> worksheet by its name?

[RichB]

Yes, thank you. I think that does it.

"JE McGimpsey" wrote:

> You mean something like
>
> ='My Sheet'!A1 + 'Sheet 2'!B1
>
> ???
>
> In article <[email protected]>,
> "RichB" <[email protected]> wrote:
>
> > Is it possible, using the tools available in Excel 2002, to refer to a
> > worksheet by its name?
>