Randy, Thanks. The second suggestion work fine. I just moved the array off to an unused section of the spreadsheet then referenced the cells in the active portion of my spreadsheet. Now I can sort to my heats content. It's a great day when I learn something new!
Thank You, Donald F Lindberg _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Randy Harmelink Sent: Tuesday, September 04, 2007 1:46 PM To: [email protected] Subject: Re: [quotes-plus] FW: Barron's new B400 index True. Just don't sort the array-entered portion -- the array-entered formulas will recalculate quickly after you sort the column that includes the ticker symbols. Or, if you want to sort on one of the returned fields, just reference it in a column that is part of the database that can be sorted. Or, you could just array-enter it by row and copy down. That would at least cut your access down to 400 Internet data retrievals instead of 3200. On 9/4/07, Don Lindberg <[EMAIL PROTECTED] <mailto:dlindber%40sbcglobal.net> net> wrote: > I see the value of the array entry for speed of download, but I want the capability of sorting > the data on different columns, and my understanding is Excel doesn't allow you to move cells > that make up an array formula. If I am wrong in my assumption please let me know.
