Indirect
Assume we can't see your worksheet and formula you are attempting to create
using the INDIRECT function.
Now try a re-post with that information.
Gord Dibben MS Excel MVP
On Tue, 26 Aug 2008 05:57:01 -0700, waldorf
wrote:
i am referencing a worksheet using the indirect function.
excel is automatically adding the active worksheet name to the formula which
returns #REF. how can i how can i stop it from automatically adding the sheet
name?
thanks,
|