Try
[VBA]Dim myArray[/VBA]
myArray = Range("A110").Value
Try
[VBA]Dim myArray[/VBA]
myArray = Range("A110").Value