ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   arrays (https://www.excelbanter.com/excel-programming/428873-arrays.html)

JJF

arrays
 
i have

arrMontana = Sheets("MONTANA").range("rang*eMONTANA").value
arrArkansas= Sheets("ARKANSAS").range("rangeARKANSAS").value

Is it possible to have arrUSA (arrmontana + arrArkansas) all at once?

Jim Cone[_2_]

arrays
 
Dim arrUSA as variant
arrUSA = Array(arrMontana, arrArkansas, arrOregon)
--
Jim Cone
Portland, Oregon USA




"JJF"
wrote in message
i have

arrMontana = Sheets("MONTANA").range("rang*eMONTANA").value
arrArkansas= Sheets("ARKANSAS").range("rangeARKANSAS").value

Is it possible to have arrUSA (arrmontana + arrArkansas) all at once?



All times are GMT +1. The time now is 02:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com