ExcelBanter - Refer to Excel Worksheet by its name

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Refer to Excel Worksheet by its name (https://www.excelbanter.com/excel-worksheet-functions/10385-refer-excel-worksheet-its-name.html)

RichB

Refer to Excel Worksheet by its name

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

JE McGimpsey

You mean something like

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

???

In article ,
"RichB" 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 ,
"RichB" wrote:

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

All times are GMT +1. The time now is 02:17 AM.