I can not work out how to pass a range parameter that works across sheets to a custom macro.
E.g. In a cell on a spreadsheet: =FNMYCUSTOMFUNCTION(Sheet1.B41:Sheet6.C88) Function declaration: Function FNMYCUSTOMFUNCTION(dte, rng) Returns Err:504 Error in parameter list. Note that =SUM(Sheet1.B41:Sheet6.C88) works as I'd expect summing all the values on all 6 sheets between B41 and C88. Note also that =FNMYCUSTOMFUNCTION(Sheet1.B41:C88) also works as expected - passing a two dimensional array to the variable rng. Thanks, Ian --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
