ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   2 Dimensional Array (https://www.excelbanter.com/excel-programming/274655-re-2-dimensional-array.html)

Tom Ogilvy

2 Dimensional Array
 
Dim idex as Integer
Dim sArr(1 to 6) as String

sArr(1) = "A.txt"
sArr(2) = "B.txt"
sArr(3) = "C.txt"
sArr(4) = "D.txt"
sArr(5) = "E.txt"
sArr(6) = "F.txt"

idex = 3
msgbox sArr(idex)


--
Regards,
Tom Ogilvy





Does anyone have an example of a 2-D array that basically
performs like the loop-up above? I do not want to nest if
statements, does not look proper.

Thanks in adavance,

Mark Frank





All times are GMT +1. The time now is 06:28 PM.

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