Thank. I will definitely read tomorrow. I am using an temp array copy of the raw data for reading values. I decided not to use an array for the output as I did not expect much gain. The program runs in seconds anyway as I just got my first I believe successful run moments ago. Still have to doublecheck values. Once I get it fully debugged would love to have your suggestions about how to make it more VBA "correct". It is not that long. Probably not more than 150 lines or so of executable code and much of that is just the variable definitions.
On Sun, Apr 15, 2012 at 2:27 AM, Asa Rossoff <a...@lovetour.info> wrote: > Just came across a simple example using an array to manipulate cell values, > then put only values that got changed back to the worksheet. It also has a > range/index equivalent sample, and a range/selection/offset example (this is > often the sort of thing first-time macro writers end up with after modifying > recorded macros). The read and write speed of the three methods are > compared. > > > > Excel Blog: What is the fastest way to scan a large range in Excel? > > > > It doesn't cover use of Evaluate to perform operations on a range without a > VBA loop, but it's a good article with straightforward examples. > > > > Asa > > > > -----Original Message----- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Domain Admin > Sent: Wednesday, April 11, 2012 10:49 AM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Why is usedrange here returning the entire > spreadsheet? > > > > The msgbox example seems to have an error but with other reading I > > think maybe but not certain I got it. > > > > I got the array version of the rounding to work. The evaluate version > > is slightly faster but the array version > > way faster than the for each or for index versions. > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
