Search results for query: *

I am trying to populate an array from data in an opened EXCEL file and can't get it to work. I need to populate a 2 dimensional array from Range("G7:H700"), for example. I did not include any code here since I have tried many ways and all have raised errors. Would someone please offer a...