=CELL("filename",A1)

--
Gary''s Student - gsnu200717


"Demetri" wrote:

Hi,

I want to get a worksheet name into a cell in the worksheet, such as
=cell("filename")
, but I want to keep the correct name for the correct worksheet.

If the above formula is used, every time the worksheet is recalculated the
value of the cell changes depending on the name of the worksheet that you are
in.

So, if the formula is in sheet aaa and you are working in sheet bbb and
recalculate, when you return to sheet aaa the name in the cell will be bbb
rather than aaa.

If you can help please do.

Thanks

--
Demetri
Johannesburg
South Africa