El Bee wrote:
I have a spreadsheet that gets clobbered from time to time by data
entry folks. Part of the problem is a macro that can't find a
specific worksheet because the name may have been changed.
Is there a way, using a macro that can look at each worksheet and
capture it's name and then paste that name into a cell somewhere on a
specific worksheet.

Just trying to make my day a bit easier.

Maybe this can help you...

This formula gives the name of the worksheet in which it's written:

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


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy