software

Hi

Is it possible to use the worksheet name in a fomula? I want it to be
retrieved automatically so I can do

=VLOOKUP(lt;lt;automatically get worksheet namegt;gt;;A1:A10;2)

and similar other operations. I do not want to manually enter the name since
I would like to be able to copy this formula to alot of
worksheets and I'm trying to reduce the time it takes to copy such formulas
around.
Would CELL(quot;Addressquot;) help or do you just want the active sheet to be
returned? If the latter, there doesn't seem to be an Excel function so
here's a user defined function (just paste it into a new module of your
workbook):

Function thisSheet()
thisSheet = ActiveCell.Parent.Name
End Function

quot;Andreas HÃ¥kanssonquot; wrote:

gt; Hi
gt;
gt; Is it possible to use the worksheet name in a fomula? I want it to be
gt; retrieved automatically so I can do
gt;
gt; =VLOOKUP(lt;lt;automatically get worksheet namegt;gt;;A1:A10;2)
gt;
gt; and similar other operations. I do not want to manually enter the name since
gt; I would like to be able to copy this formula to alot of
gt; worksheets and I'm trying to reduce the time it takes to copy such formulas
gt; around.
gt;
gt;
gt;

Use CELL():=MID(CELL(quot;Filenamequot;,A1),FIND(quot;]quot;,CELL(quot;Filenamequot;,A1)) 1,255)

will return only the worksheet name (a part of the full path name)
--
Gary''s Studentquot;Martinquot; wrote:

gt; Would CELL(quot;Addressquot;) help or do you just want the active sheet to be
gt; returned? If the latter, there doesn't seem to be an Excel function so
gt; here's a user defined function (just paste it into a new module of your
gt; workbook):
gt;
gt; Function thisSheet()
gt; thisSheet = ActiveCell.Parent.Name
gt; End Function
gt;
gt; quot;Andreas HÃ¥kanssonquot; wrote:
gt;
gt; gt; Hi
gt; gt;
gt; gt; Is it possible to use the worksheet name in a fomula? I want it to be
gt; gt; retrieved automatically so I can do
gt; gt;
gt; gt; =VLOOKUP(lt;lt;automatically get worksheet namegt;gt;;A1:A10;2)
gt; gt;
gt; gt; and similar other operations. I do not want to manually enter the name since
gt; gt; I would like to be able to copy this formula to alot of
gt; gt; worksheets and I'm trying to reduce the time it takes to copy such formulas
gt; gt; around.
gt; gt;
gt; gt;
gt; gt;