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.

Bob Phillips has various example formulae he

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

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

Hope this helps.

Pete

"SGangs" wrote in message
...
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.

Thank You Pete
The solution worked.

"Pete_UK" wrote:

Bob Phillips has various example formulae he

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

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

Hope this helps.

Pete

"SGangs" wrote in message
...
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.

You're welcome - thanks for feeding back.

Pete

On Dec 15, 11:13*am, SGangs wrote:
Thank You Pete
The solution worked.