Copy range of data into the table or list datatype

Hi guys,
I want to copy the range of data from one sheet and store it into some temporary table or list data type... and then i want to add values of one of its column.....

for example...

Dim myTempRange as Range
Dim mySum as Double
myTempRange = Range("A:D")
mySum=sum(myTempRange.columns(4))

It sounds like what you need is a variant, such as:

Please Login or Register  to view this content.

You can also do the opposite: Range("A1:D" & nLastRow) = vArray
As long as the region is the same size.