View Single Post
Old 08-01-2007, 10:25 AM
contiw contiw is offline
Join Date: Aug 2007
Posts: 2
Default Range names and length stuff. Please help-a-noob.

This formula works ok.
If I rename range E9:E1494 as "Col_1" and change the formula to
I get #VALUE error.
The range is formatted as number.

Also ...

If I delete some cells in a range, referring formulae are modified accordingly, but if I add cells in the range the formulae do not recognize the change

Thanks for helping.
Reply With Quote