Charlie,

To add to Bob's post...
You cannot assign to an array in Excel 97.
In later versions you must use the Value property of the
range not the Text property, so...
MyGrid= Range("B2:D5").Value

Jim Cone
San Francisco, USA



"Charlie" wrote in message
...
Hi,
I can move a 2D array to a range but how do I move a selected range to a 2D
array?
Dim MyGrid() As String
Range("A9").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
MyGrid = Selection.Text
(or)
MyGrid = Range("B2:D5").Text
Thanks