Indirect question

  • Thread starter saveas getting rid of formulas
  • Start date
S

saveas getting rid of formulas

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
 
J

Jonathan Cooper

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

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

saveas getting rid of formulas

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
 
B

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)
 
F

flummi

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

Hans
 
S

saveas getting rid of formulas

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