Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to read Data from spreadsheet to VBA?

Status
Not open for further replies.

gbam

Civil/Environmental
Jan 20, 2003
878
US
Quick question-
Is it possible to enter data, array format, in a spreadsheet then read it into VBA to perform computations?
 
Replies continue below

Recommended for you

gbam,
The quickest way to read spreadsheet array:

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

vtArray becomes a two-dimensional array.

good luck!
 
Thank You!
I will give it a try.
 
if its a function then you can also transfer the array when calling the function.

Best regards

Morten
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top