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))