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

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" <(E-Mail Removed)> wrote in message
news:5314AF7B-36A1-47FD-923C-(E-Mail Removed)...
>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
>
>