Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
dynamic named ranges
1 view
Skip to first unread message
striker
Oct 17, 2007, 10:28:36 AM10/17/07
to
In Excel I frequently use dynamic named ranges.
I have tried them is Calc with no success.
Here is what my attempt looked like:
1) click on insert
2) click names
3) click define
4) type the name "myrange"
5) in the box 'assigned to' use the formula:
=offset($a$1;0;0;counta($a;$a),1)
I have tried them is Calc with no success.
Here is what my attempt looked like:
1) click on insert
2) click names
3) click define
4) type the name "myrange"
5) in the box 'assigned to' use the formula:
=offset($a$1;0;0;counta($a;$a),1)
I get an 'Invalid Expression' error.
Any help would be greatly appreciated.
TIA,
Kevin
0 new messages