Hello mtma,

Your question is very broad. An example would help. If you just want a general answer, here is a way to grab all data from a sheet into an array:
Dim arr as variant
arr = activesheet.usedrange.value