worksheet name in cell

[imillar]

is there a way to insert the worksheet name into a cell
EG:
sheet 1 name is "John"
sheet 2 name is "brian"

on another worksheet "summary" i want to insert these two worksheet names in cells a1 and a2.

regards

 

[pjmorris]

Hi Aladdin,

Just got directed to this from another post. I've never come across the get.workbook structure before - where is it documented? Also, it seems strange that the function works when used to define a name, but doesnt work when put into a worksheet cell.

Grateful if you could enlighten me.

Many thanks

 

[Aladin Akyurek]

Hi Aladdin,

Just got directed to this from another post. I've never come across the get.workbook structure before - where is it documented? Also, it seems strange that the function works when used to define a name, but doesnt work when put into a worksheet cell.

Grateful if you could enlighten me.

Many thanks

There is more on such macros on this very site. For more, see: http://www.ashishmathur.com/tag/xlm-4-0-macro/

 

[pjmorris]

Many thanks for this - interesting that a macro can feature in a Name definition, I'd never come across that before.

Regards