See
http://www.xldynamic.com/source/xld.xlFAQ0002.html
--
HTH
RP
(remove nothere from the email address if mailing direct)
"kjbrr" wrote in message
...
I'm trying to have a cell equal, in part, the sheet tab name. My tabs are
dates, and I'd love to have the date references (in the worksheet cells)
automatically update when I change the sheet name.