Posted By

Scooter on 04/23/09


Tagged

excel


Versions (?)

Worksheet Name


 / Published in: Other
 

URL: http://www.tribbs.co.uk/showtip.php?myID=236&start=4

In speed tests, a VBA function using ActiveSheet.Name appears to be quite faster, but this formula can accomplish the same thing in situations where a macro solution is not preferable.

  1. MID(CELL("filename"),(FIND("]",CELL("filename"))+1),50)

Report this snippet  

You need to login to post a comment.