Code in Cells

[Murtaza]

Can it possible to run code without using VBA editor, like in cell A1:
=Activesheet.name
OR
activecell.value=activesheet.name

any comments?

 

[Paul B]

Murtaza, this will give you the sheet name
=MID(CELL("filename",A2),FIND("]",CELL("filename",A2))+1,255)
file must be saved first

-
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **