Indirect question
The row() needs to reference something. Try this, assuming you are entering
the formula on row 1.
=INDIRECT("Domestic!A"&ROW(A1))
"saveas getting rid of formulas" wrote:
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
|