On Wed, 2006-03-01 at 09:54 +0100, Niklas Nebel wrote: > Ian Laurenson wrote: > > 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) > > That's not supported. You should separate the range into several > single-sheet range parameters.
Thanks Niklas. I have submitted an enhancement request: http://qa.openoffice.org/issues/show_bug.cgi?id=62694 Separating the range into several single-sheet range parameters is not a particularly satisfactory solution as spreadsheets using such custom functions would be harder to maintain. E.g. Add a new sheet and every instance of the function would have to be changed. Cheers, Ian --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
