Code in Cells

  • Thread starter Thread starter Murtaza
  • Start date Start date
M

Murtaza

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

any comments?
 
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 **
 
Back
Top