How to read Data from spreadsheet to VBA?
How to read Data from spreadsheet to VBA?
(OP)
Quick question-
Is it possible to enter data, array format, in a spreadsheet then read it into VBA to perform computations?
Is it possible to enter data, array format, in a spreadsheet then read it into VBA to perform computations?





RE: How to read Data from spreadsheet to VBA?
RE: How to read Data from spreadsheet to VBA?
The quickest way to read spreadsheet array:
dim vtArray
vtArray = range("A1:B25")
vtArray becomes a two-dimensional array.
good luck!
RE: How to read Data from spreadsheet to VBA?
I will give it a try.
RE: How to read Data from spreadsheet to VBA?
Best regards
Morten