View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andreas Håkansson
 
Posts: n/a
Default Use worksheet name

Hi

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

=VLOOKUP(<<automatically get worksheet name;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.