Chip Pearson wrote:
You should add a cell reference (it doesn't matter what cell) to the CELL
functions. E.g.,

CELL("filename",A1)

Without the reference, the value returned by CELL is the workbook/worksheet
that is active when the cell containing the formula is calculated. If a
sheet other than the sheet containing the formula is active, you'll get the
wrong result.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)


"Ken Johnson" wrote in message
ups.com...


Thanks Chip

Ken Johnson