Named ranges?
Posted by Rob on July 20, 2001 6:08 PM
Another question :) Ok, i have a named range on a page (A1:A5000). I have another worksheet that is linked to this page which does quite a few calculations using the data from the first page. The problem is that it takes about 2 min for the 2nd page to update all the linked data. Im assuming this is because it has to do so many calculations on the big range of A1:A5000. I was wondering if there is a way (maybe a macro?) to define a range so that it will only equal the cells with data. For example: if there is only data from cells A1:A500 ,then that would be the range, but it would change if another row had data input to it.
This or any other ideas would be greatly appreciated.
Thanks
Posted by Aladin Akyurek on July 21, 2001 12:15 AM
Rob,
You can make your range a named dynamic range. Activate Insert|Name|Define. Select the name you have assigned to the range. Change its "Refers to" to:
=OFFSET(x!$A$1,0,0,COUNTA($A:$A),1)
where x is the name of the sheet (or "page").
Aladin
=================
Posted by Barrie Davidson on July 21, 2001 7:21 AM
Aladin, that's wicked!!! Love to learn new things (NT)
