On Fri, 3 Feb 2006 07:57:24 -0800, saveas getting rid of formulas
. com wrote:

I have the following statement in a parameter going against sql server
=indirect("Domestic!A"&row()) it works fine when I first put it in and
retrieve data.
The problem is when I save the spread sheet and then later open it back up.
The following message then occurs
"Coluld not obtain parameter from reference (Bad name or workbook not open).
Proceed to prompt for value?"

Is there another function that I need to use in a parm external situation
other than indirect? Thank YOu

You could use Longre's INDIRECT.EXT function, available in his free
morefunc.xll available at http://xcell05.free.fr

Unlike the INDIRECT built-in function, INDIRECT.EXT can also return the value
of a cell whose workbook is closed.


--ron