worksheet.name

B

Bob Phillips

Randy,

As long as the file has been saved at some time, use this formula in your
target cell
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename"
,A1),1))

The A1 is not relevant, it just anchors the formula to the worksheet the
formula is in.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro - onAction arguments 2
Worksheet name 4
Run macro on all files in a specific folder 3
string extraction not working. 4
Case not recognized in Select Case 4
Probably simple 3
Copying worksheet into another worksheet 2
Strange probem with capitalization of object 10

Top