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,