View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default populating cells with sheet names

See

http://www.mcgimpsey.com/excel/cell_function.html

In article .com,
"bjrbrain" wrote:

Hi from a newb... I'm creating a file with numerous sheets and want to
automatically populate a cell with the sheet name. That way, if a
sheet name changes (which it does often) the cell in question will
populate with the new sheet name without any intervention from the
user.

TIA for your help!