Back in Apr 13 2004, 10basetom posted about what he believed to be a
flaw with the Excel function CELL. The replies corrected that belief. I
believe that I have found a bug with CELL. I'm using Excel 2000
(9.0.6926 SP-3).

Create a one-worksheet workbook. Name the worksheet George and save the
workbook as George--the same name as the one worksheet. Now enter =CELL("filename",A1) into any cell. My results are not as expected. The workbook name is not
surrounded by brackets and the worksheet name is missing.

Either, change the name of the workbook, the worksheet, or add another
worksheet and then the results are as expected.

Does this error exist in later versions of Excel?

Art H


--
ArtHendrickson
------------------------------------------------------------------------
ArtHendrickson's Profile: http://www.excelforum.com/member.php...o&userid=28755
View this thread: http://www.excelforum.com/showthread...hreadid=484460