Dec 7, 2005 #1 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?
Quick question- Is it possible to enter data, array format, in a spreadsheet then read it into VBA to perform computations?
Dec 7, 2005 #2 melone Electrical Aug 10, 2001 1,233 US It is done in Excel ALL the time. Upvote 0 Downvote
Dec 7, 2005 #3 yakpol Structural Jun 1, 2001 450 CA 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
gbam, The quickest way to read spreadsheet array: dim vtArray vtArray = range("A1:B25") vtArray becomes a two-dimensional array. good luck!
Dec 7, 2005 Thread starter #4 gbam Civil/Environmental Jan 20, 2003 878 US Thank You! I will give it a try. Upvote 0 Downvote
Dec 7, 2005 #5 MortenA Petroleum Aug 20, 2001 2,996 DK if its a function then you can also transfer the array when calling the function. Best regards Morten Upvote 0 Downvote
if its a function then you can also transfer the array when calling the function. Best regards Morten