storing variable single column range into array

Hello,

Using VBA i would like to copy a single column range of data to a 2-dimensional table inside a workbook.
The problem is that the range does not always start from the first measure but it does go continuous by number until the end (1..198, 154..198, 25..198 etc.)
Since i can't reference table cells to values that sometimes do not exist i was thinking of making arrays of both the single column range and the table cells.
This way,by looping (there are not more than 500 values to be copied) i would be matching the cell references and knowing which value should be copied and to which cell.