How to capture the Sheet name in a cell

[SGangs]

I was creating a contents sheet with the sheet names (no. of sheets are
constant). Since the sheet name can be modified, i need to capture the sheet
name in real time mode.

 

[Pete_UK]

Bob Phillips has various example formulae here:

http://www.xldynamic.com/source/xld.xlFAQ0002.html

to enable you to capture path, filename, sheetname etc.

Hope this helps.

Pete

 

[SGangs]

Thank You Pete
The solution worked.

Bob Phillips has various example formulae here:

http://www.xldynamic.com/source/xld.xlFAQ0002.html

to enable you to capture path, filename, sheetname etc.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete