Read range into an array, work with it, then paste it back to a sheet.

[wolis]

Hello masters of Excel!

Lets say I have a simple table with data like this in ABC columns:
Alan 500 Car
Susan 200 Bike
John 1 Foot
Cat 80 Ship
Dog 43 Boat

Is there a simple way top read it into a 2d VBA array (Boat being at adress [5,30], 200 being at adress [2,2]?
//I do some stuff with the array here//
Then after that being done I want to "paste" the array back to the worksheet the way it looked before (the number of rows in x dimension, number of columns in y dimension).
Can this be done without looping, but simply pasting the whole range or even better collumns 1 by 1?
Looping through each value does not do much good here, as i have a very large data table, that takes too long to loop through.

Best Regards,
Valters

[JosephP]

Please Login or Register  to view this content.

for instance

[wolis]

Thanks Joseph!
This does exactly what I want!