Check out

http://www.mcgimpsey.com/excel/formu..._function.html



In article ,
"Hawk186" wrote:

The tab is named '522' and I want '522' to show up in a cell in the worksheet
such as A1. I know that =CELL can be used to get the filenam, but can it be
used to get the tab name? If not, is there another function that will?