LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
saveas getting rid of formulas
 
Posts: n/a
Default Indirect question

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying a formulae down a column that includes an INDIRECT A.Webb Excel Discussion (Misc queries) 10 January 14th 06 03:42 AM
Pivot table question gary Excel Discussion (Misc queries) 1 January 10th 06 06:25 PM
Using the Indirect function with a sheet number instead of a sheet name JDB Excel Worksheet Functions 5 December 31st 05 03:03 PM
referencing named formula using INDIRECT function [email protected] Excel Worksheet Functions 19 May 11th 05 09:48 AM
INDIRECT function question Joe Excel Worksheet Functions 1 February 14th 05 03:54 PM


All times are GMT +1. The time now is 07:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"