Peter T wrote:
Particularly with respect to the broad claim

"I have done some studying on this issue and I find that in vb version 6,

Dim MyArray1()

isn't an array of variants."

users should be aware that if the array is to be loaded with looping,
The Variant() array [Dim MyArray()] appears (from limited testing) to
load faster than the array contained within a Variant variable [Dim
MyArray].

Alan Beban


Alan,

I appreciate you originally qualified with "This post relates to xl2000",
and in latest you refer to loading by looping. But if it's expected to cater
for Excel 97 and loading by "dumping", Dim MyArray1() fails for me.

As it does for everyone; that was acknowledged in the original thread
two years ago. The issue arose from Microsoft's change in xl2000, which
allowed direct assignment of a worksheet range to MyArray after Dim
MyArray().

I believe that that indeed was what Tom Ogilvy referred to as
counterproductive with respect to the use of Dim MyArray().

Thanks for your interest and input.

Alan Beban