Posted to microsoft.public.excel.programming

Stratuser

external usenet poster

Posts: 63

Assigning Range to Array

I often assign ranges to two-dimensional arrays. I've noticed that I can do
it by declaring the variable as a variant variable, or as an array of
variants. It seems to work either way. Which of these two is better?

Dim MyArray as Variant
MyArray = Range("MyRange").Value

or

Dim MyArray() As Variant
MyArray = Range("MyRange").Value

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assigning range to array not working	Marston	Excel Programming	2	August 12th 04 11:38 PM
Assigning 10x1 array to 2nd collumn of 10x3 array	Alan Beban[_2_]	Excel Programming	0	July 30th 04 01:38 AM
Assigning 10x1 array to 2nd collumn of 10x3 array	Myrna Larson	Excel Programming	0	July 29th 04 11:57 PM
Assigning array to range inside Excel Object	Jon Peltier	Excel Programming	0	April 1st 04 11:14 PM
Assigning Array Values	MWE[_16_]	Excel Programming	6	January 26th 04 04:35 AM

All times are GMT +1. The time now is 05:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us