Range object to Array object conversion
 

You haven't provided enough information to identify the problem, like
how MyArray1 was declared, and what happens when it "doesn't work"--like
what's the error message?

Alan Beban

Yogesh wrote:
HI ,
The following code works fine :
'eg. of array being assigned to a range object
.Range("A1:A2").Value = MyArray
'just wanted to know whether the reverse is possible
' i.e. something like ---
' MyArray1 = .Range("A1:A3") 'This not working with VBA

Thanks,
Yogesh