View Single Post
  #1   Report Post  
Michael Excel Dude Michael Excel Dude is offline
Junior Member
 
Posts: 12
Default Show field or range name in a cell

Hi. I'm trying to keep all my naming conventions documented, so I've set up a sheet in my work book listing all the cell or range names I've created.

Is there any way to have a cell show the assigned name of another cell? Can this formula be put directly in the cell

example =name($B$1)

Thanks