I'm not exactly sure of what you are trying to do. What is the purpose of
the worksheets.? Why did you put the name of the worksheet inside the cell?


You can give the cell a Name and have the name of the cell inside the formula.


Please provide more information about what you are trying to do.
------------------------------------------------------------------------------
----------------------------------------------------------------------
wrote:
Is there a way to change the sheet name in a formula with a name that
is stored in a cell?
I have a vlookup that looks in sheet1 range. I have in the Cell a10 the
name of the sheet I want to lookup the value.

Thanks
Gastón

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200611/1