parse it out of the

=CELL("filename",A1)

The workbook must have been saved at least once for this to work.

--
Regards,
Tom Ogilvy

"dfrosticle" wrote in message
...
I have tried using the following but there must be a better and easier way
to
get the &[Tab] name into a cell of a sheet. Any ideas anyone ??