How to read Data from spreadsheet to VBA?

[gbam]

Quick question-
Is it possible to enter data, array format, in a spreadsheet then read it into VBA to perform computations?

 

[melone]

It is done in Excel ALL the time.

 

[yakpol]

gbam,
The quickest way to read spreadsheet array:

dim vtArray
vtArray = range("A1:B25")

vtArray becomes a two-dimensional array.

good luck!

 

[gbam]

Thank You!
I will give it a try.

 

[MortenA]

if its a function then you can also transfer the array when calling the function.

Best regards

Morten