See
http://www.xldynamic.com/source/xld.xlFAQ0002.html
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
. ..
is there a function that returns the name of the sheet it is on?