How to read Data from spreadsheet to VBA?

• Dec 7, 2005

• #2

melone

Electrical

Aug 10, 2001

1,233

It is done in Excel ALL the time.

 

Upvote 0 Downvote

• Dec 7, 2005

• #3

yakpol

Structural

Jun 1, 2001

450

gbam,
The quickest way to read spreadsheet array:

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

vtArray becomes a two-dimensional array.

good luck!

 

Upvote 0 Downvote

• Dec 7, 2005

• Thread starter
• #4

gbam

Civil/Environmental

Jan 20, 2003

879

Thank You!
I will give it a try.

 

Upvote 0 Downvote

• Dec 7, 2005

• #5

MortenA

Petroleum

Aug 20, 2001

2,996

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

Best regards

Morten

 

Upvote 0 Downvote