View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
El Bee El Bee is offline
external usenet poster
 
Posts: 58
Default Macro to capture worksheet names

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.