You need to use numeric values, else you get value errors

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Barry Clark"
wrote in message
...

haha. Now that I have enabled Analysis Toolpak, I get #Value.

Anyways, I am using 2003. I still have not been able find away to use
the sheet name as a cell value.


--
Barry Clark
------------------------------------------------------------------------
Barry Clark's Profile:
http://www.excelforum.com/member.php...o&userid=35267
View this thread: http://www.excelforum.com/showthread...hreadid=550409