Indirect question

[Guest]

I'm using the following function in a parameter
=indirect("Domestic!A"&row())
It works great until I save the spread sheet. When I reopen I get the
following error message and the parm has disappeared?

Could not obtain parameter from reference (Bad name or workbook not open).
Proceed to prompt for value.

Does anyone know why this is happening? Thank You

 

[Guest]

The row() needs to reference something. Try this, assuming you are entering
the formula on row 1.

=INDIRECT("Domestic!A"&ROW(A1))

 

[Guest]

No this had the same result.
both
=INDIRECT("Domestic!A"&ROW(A1))
and
=INDIRECT("Domestic!A"&ROW( ))
work and return the cell value correctly. I get the error when I then
save the spread sheet and try to reopen it. Thanks

 

[Bob Phillips]

No, ROW() implicitly declares the current row, the row the formula is in.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Guest]

It's a parameter to what?

 

[flummi]

Strange. I copied your formula exactly into a worksheet, saved and
re-opened it and it worled fine.

Hans

 

[Guest]

it is a parameter for an external data source - sql server