software

is there a function that returns the name of the sheet it is on?
Adam, here is one way,

=MID(CELL(quot;filenamequot;,A1),FIND(quot;]quot;,CELL(quot;filenamequot;,A1)) 1,255)

file must be saved first--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 amp; 2003

quot;Adam Kroger @hotmail.comgt;quot; lt;adam_krogerlt;nospamgt; wrote in message
. ..
gt; is there a function that returns the name of the sheet it is on?
gt;
gt;
See www.xldynamic.com/source/xld.xlFAQ0002.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Adam Kroger @hotmail.comgt;quot; lt;adam_krogerlt;nospamgt; wrote in message
. ..
gt; is there a function that returns the name of the sheet it is on?
gt;
gt;
Adam

UDF.............

Function SheetName(Optional ByVal rng As Range) As String
Application.Volatile
If rng Is Nothing Then Set rng = Application.Caller
SheetName = rng.Parent.Name
End Function

OR........

See Bob Phillips' site for more on sheet and filenames.

www.xldynamic.com/source/xld.xlFAQ0002.htmlGord Dibben Excel MVP

On Wed, 14 Dec 2005 18:02:48 -0600, quot;Adam Krogerquot;
gt; wrote:

gt;is there a function that returns the name of the sheet it is on?
gt;

Thanksquot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote in message
...
gt; Adam
gt;
gt; UDF.............
gt;
gt; Function SheetName(Optional ByVal rng As Range) As String
gt; Application.Volatile
gt; If rng Is Nothing Then Set rng = Application.Caller
gt; SheetName = rng.Parent.Name
gt; End Function
gt;
gt; OR........
gt;
gt; See Bob Phillips' site for more on sheet and filenames.
gt;
gt; www.xldynamic.com/source/xld.xlFAQ0002.html
gt;
gt;
gt; Gord Dibben Excel MVP
gt;
gt; On Wed, 14 Dec 2005 18:02:48 -0600, quot;Adam Krogerquot;
gt; gt; wrote:
gt;
gt;gt;is there a function that returns the name of the sheet it is on?
gt;gt;