View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jonathan Cooper
 
Posts: n/a
Default 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