View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stratuser Stratuser is offline
external usenet poster
 
Posts: 63
Default 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