Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Can I use INDIRECT to create different named ranges on diffent Calc sheets?

I would like to use a single LibreOffice macro to sort different ranges of data on different sheets.

For example, on Sheet 1, I want to sort, A1:B10, but on Sheet 2, I want to sort A1 to B12; in both cases, using Column A as the key.

I have tried making named ranges such as $A$1:INDIRECT(S1) where S1 contains the text $B$10, but the name doesn't appear in the named ranges list.

As an experiment, I also tried a named range of a single cell INDIRECT($S$1), which I know works in a cell formula, but the name still doesn't appear in the list.

Am I doing something wrong, or is this just not possible?

Can {Can I use INDIRECT to create different named ranges on diffent Calc sheets?sheets?[Solved]

I would like to use a single LibreOffice macro to sort different ranges of data on different sheets.

For example, on Sheet 1, I want to sort, A1:B10, but on Sheet 2, I want to sort A1 to B12; in both cases, using Column A as the key.

I have tried making named ranges such as $A$1:INDIRECT(S1) where S1 contains the text $B$10, but the name doesn't appear in the named ranges list.

As an experiment, I also tried a named range of a single cell INDIRECT($S$1), which I know works in a cell formula, but the name still doesn't appear in the list.

Am I doing something wrong, or is this just not possible?