Is it possible to have a cell just quote the worksheet name?
 

Ie. My workbook has 5 worksheets, England, Scotlans etc

Can I have cell A7 of each sheet just quote the name?

Thanks!

Is it possible to have a cell just quote the worksheet name?
 

You Could have something like this in cell A7 in each worksheet

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,30)

regards

Paul


DannyS wrote:
Ie. My workbook has 5 worksheets, England, Scotlans etc

Can I have cell A7 of each sheet just quote the name?

Thanks!

Is it possible to have a cell just quote the worksheet name?
 

This, in any cell will return the SheetName, once the file has been saved.

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

Vaya con Dios,
Chuck, CABGx3




"DannyS" wrote:

Ie. My workbook has 5 worksheets, England, Scotlans etc

Can I have cell A7 of each sheet just quote the name?

Thanks!

Is it possible to have a cell just quote the worksheet name?
 

Super, thanks guys

"CLR" wrote:

This, in any cell will return the SheetName, once the file has been saved.

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

Vaya con Dios,
Chuck, CABGx3




"DannyS" wrote:

Ie. My workbook has 5 worksheets, England, Scotlans etc

Can I have cell A7 of each sheet just quote the name?

Thanks!