This function returns incorrect value sporadically

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I'm using this function in Excel '07 to return the worksheet name into cell
B1 on a sheet.

=RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$A$1))-FIND("]",CELL("filename",$A$1)))

If the sheet name is "WORKSHEET", every so often the function returns
".xlsm]WORKSHEET. This usually occurs when I go to another worksheet, then
come back to this one. When I go into the cell (F2) then hit enter, it
corrects itself.

I have calculation set to automatic.

The workbook size is only about 16MB.

Any ideas?
 
I'm unable to duplicate what you describe.

Try this formula. Does the same thing just written differently:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
 

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

Vlookup and return sheet name also 2
lookup across multiple sheets & return sum of cells 5
Need help with Hlookup - need to return values below the matched c 2
Scrabble Value calculation for Welsh words 0
information functions 3
Need Function for Year-to-Date spent total 3
use sumif with criteria including sheet name 4
Pulling Tab Name of a Different Tab Than What I'm Working In 7

Back
Top