Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
03 vs 07: speed with different methods of referencing ranges?
I did some minor testing on 2003 with bringing in arrays as reference vs
variant: Dim rng As Range Dim rng2 As Variant RowCount = lastRow(Sheet2) Set rng = Sheet2.Range("A1:Z" & RowCount) rng2 = Sheet2.Range("A1:Z" & RowCount).Value I then tested to see if processing on either was faster, using some simple math calculations on my range content. For my sample data, they were within a second of each other. My workbook will likely be used by coworkers in another state who have 2007, so I figured it would be wise to ask if anyone has noticed dramatic speed differences in 2007 between processing data in one vs the other type of range reference. I'll be working on some very large ranges later, so I want to make sure I'm not shooting myself in the foot with whichever one I end up using. Thanks, Keith |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
03 vs 07: speed with different methods of referencing ranges?
Excel 2007 was significantly slower than 2003, although Excel 2007 SP2 has
made things much better. see http://www.decisionmodels.com/VersionCompare.htm for a detailed comparison. Charles ___________________________________ The Excel Calculation Site http://www.decisionmodels.com "ker_01" wrote in message ... I did some minor testing on 2003 with bringing in arrays as reference vs variant: Dim rng As Range Dim rng2 As Variant RowCount = lastRow(Sheet2) Set rng = Sheet2.Range("A1:Z" & RowCount) rng2 = Sheet2.Range("A1:Z" & RowCount).Value I then tested to see if processing on either was faster, using some simple math calculations on my range content. For my sample data, they were within a second of each other. My workbook will likely be used by coworkers in another state who have 2007, so I figured it would be wise to ask if anyone has noticed dramatic speed differences in 2007 between processing data in one vs the other type of range reference. I'll be working on some very large ranges later, so I want to make sure I'm not shooting myself in the foot with whichever one I end up using. Thanks, Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named ranges in VBA | Excel Discussion (Misc queries) | |||
Dynamic Ranges: Speed Issue | Excel Worksheet Functions | |||
Referencing named ranges | Excel Programming | |||
Problem with speed of PasteSpecial for large ranges | Excel Programming | |||
looping through ranges: how to speed up? | Excel Programming |