Страница: 1 |
|
Вопрос: помогите найти ошибку((
|
Добавлено: 19.01.10 16:00
|
|
Автор вопроса: ilang-ilang | ICQ: 355115304
|
Dim EnergyList() As String
ReDim EnergyList(0, 0)
Dim count_i As Integer
count_i = 0
Open file_name For Input Access Read As #1
Do While Not EOF(1)
Line Input #1, str_temp
ReDim Preserve EnergyList(count_i, 3)
...
count_i = count_i + 1
Loop
ругается в строке ReDim Preserve EnergyList(count_i, 3)
пишет subscript out og range
заранее спасибо
Ответить
|
Номер ответа: 3 Автор ответа: AngryBadger
Вопросов: 33 Ответов: 245
|
Профиль | | #3
|
Добавлено: 20.01.10 10:51
|
Что-то ты не то делаешь, значит. Тебе нужно поменять твою строчку на - ReDimPreserve EnergyList, count_i, 3
И добавить функцию VBD:
- Function ReDimPreserve(Arr, ParamArray Razm() As Variant)
- Dim g
- Dim i As Long
- Dim gs
- Dim BigDem() As Long, LowDem() As Long
-
- If Not IsNumeric(Razm(0)) And UBound(Razm) = 0 Then
- gs = Split(Razm(0), ",")
- ReDim BigDem(UBound(gs))
- ReDim LowDem(UBound(gs))
- For i = 0 To UBound(gs)
- gs(i) = LCase(gs(i))
- If InStr(1, gs(i), "to") Then
- LowDem(i) = Val(Split(gs(i), "to")(0))
- BigDem(i) = Val(Split(gs(i), "to")(1))
- Else
- BigDem(i) = Val(gs(i))
- End If
- Next
- Else
- ReDim BigDem(UBound(Razm))
- ReDim LowDem(UBound(Razm))
- For i = 0 To UBound(Razm)
- If Not IsNumeric(Razm(i)) Then
- LowDem(i) = Val(Split(LCase(Razm(i)), "to")(0))
- BigDem(i) = Val(Split(LCase(Razm(i)), "to")(1))
- Else
- BigDem(i) = Val(Razm(i))
- End If
- Next
- End If
- If UBound(BigDem) = 0 Then ReDim g(LowDem(0) To BigDem(0))
- If UBound(BigDem) = 1 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1))
- If UBound(BigDem) = 2 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2))
- If UBound(BigDem) = 3 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3))
- If UBound(BigDem) = 4 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4))
- If UBound(BigDem) = 5 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5))
- If UBound(BigDem) = 6 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6))
- If UBound(BigDem) = 7 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7))
- If UBound(BigDem) = 8 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8))
- If UBound(BigDem) = 9 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9))
- If UBound(BigDem) = 10 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10))
- If UBound(BigDem) = 11 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11))
- If UBound(BigDem) = 12 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12))
- If UBound(BigDem) = 13 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13))
- If UBound(BigDem) = 14 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14))
- If UBound(BigDem) = 15 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15))
- If UBound(BigDem) = 16 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16))
- If UBound(BigDem) = 17 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17))
- If UBound(BigDem) = 18 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18))
- If UBound(BigDem) = 19 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19))
- If UBound(BigDem) = 20 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20))
- If UBound(BigDem) = 21 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21))
- If UBound(BigDem) = 22 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22))
- If UBound(BigDem) = 23 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23))
- If UBound(BigDem) = 24 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24))
- If UBound(BigDem) = 25 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25))
- If UBound(BigDem) = 26 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26))
- If UBound(BigDem) = 27 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27))
- If UBound(BigDem) = 28 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28))
- If UBound(BigDem) = 29 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28), LowDem(29) To BigDem(29))
- If UBound(BigDem) = 30 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28), LowDem(29) To BigDem(29), LowDem(30) To BigDem(30))
- If UBound(BigDem) = 31 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28), LowDem(29) To BigDem(29), LowDem(30) To BigDem(30), LowDem(31) To BigDem(31))
- If UBound(BigDem) = 32 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28), LowDem(29) To BigDem(29), LowDem(30) To BigDem(30), LowDem(31) To BigDem(31), LowDem(32) To BigDem(32))
- If UBound(BigDem) = 33 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28), LowDem(29) To BigDem(29), LowDem(30) To BigDem(30), LowDem(31) To BigDem(31), LowDem(32) To BigDem(32), LowDem(33) To BigDem(33))
- If UBound(BigDem) = 34 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28), LowDem(29) To BigDem(29), LowDem(30) To BigDem(30), LowDem(31) To BigDem(31), LowDem(32) To BigDem(32), LowDem(33) To BigDem(33), LowDem(34) To BigDem(34))
- If UBound(BigDem) = 35 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28), LowDem(29) To BigDem(29), LowDem(30) To BigDem(30), LowDem(31) To BigDem(31), LowDem(32) To BigDem(32), LowDem(33) To BigDem(33), LowDem(34) To BigDem(34), LowDem(35) To BigDem(35))
- If UBound(BigDem) = 36 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28), LowDem(29) To BigDem(29), LowDem(30) To BigDem(30), LowDem(31) To BigDem(31), LowDem(32) To BigDem(32), LowDem(33) To BigDem(33), LowDem(34) To BigDem(34), LowDem(35) To BigDem(35), LowDem(36) To BigDem(36))
- If UBound(BigDem) = 37 Then ReDim g(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28), LowDem(29) To BigDem(29), LowDem(30) To BigDem(30), LowDem(31) To BigDem(31), LowDem(32) To BigDem(32), LowDem(33) To BigDem(33), LowDem(34) To BigDem(34), LowDem(35) To BigDem(35), LowDem(36) To BigDem(36), LowDem(37) To BigDem(37))
- On Error Resume Next
- Dim j As Long, j1 As Long, j2 As Long, j3 As Long, j4 As Long, j5 As Long, j6 As Long, j7 As Long, j8 As Long, j9 As Long, j10 As Long, j11 As Long, j12 As Long, j13 As Long, j14 As Long, j15 As Long, j16 As Long, j17 As Long, j18 As Long, j19 As Long, j20 As Long, j21 As Long, j22 As Long, j23 As Long, j24 As Long, j25 As Long, j26 As Long, j27 As Long, j28 As Long, j29 As Long, j30 As Long, j31 As Long, j32 As Long, j33 As Long, j34 As Long, j35 As Long, j36 As Long, j37 As Long
- For j = LowDem(0) To BigDem(0)
- If UBound(BigDem) > 0 Then
- For j1 = LowDem(1) To BigDem(1)
- If UBound(BigDem) > 1 Then
- For j2 = LowDem(2) To BigDem(2)
- If UBound(BigDem) > 2 Then
- For j3 = LowDem(3) To BigDem(3)
- If UBound(BigDem) > 3 Then
- For j4 = LowDem(4) To BigDem(4)
- If UBound(BigDem) > 4 Then
- For j5 = LowDem(5) To BigDem(5)
- If UBound(BigDem) > 5 Then
- For j6 = LowDem(6) To BigDem(6)
- If UBound(BigDem) > 6 Then
- For j7 = LowDem(7) To BigDem(7)
- If UBound(BigDem) > 7 Then
- For j8 = LowDem(8) To BigDem(8)
- If UBound(BigDem) > 8 Then
- For j9 = LowDem(9) To BigDem(9)
- If UBound(BigDem) > 9 Then
- For j10 = LowDem(10) To BigDem(10)
- If UBound(BigDem) > 10 Then
- For j11 = LowDem(11) To BigDem(11)
- If UBound(BigDem) > 11 Then
- For j12 = LowDem(12) To BigDem(12)
- If UBound(BigDem) > 12 Then
- For j13 = LowDem(13) To BigDem(13)
- If UBound(BigDem) > 13 Then
- For j14 = LowDem(14) To BigDem(14)
- If UBound(BigDem) > 14 Then
- For j15 = LowDem(15) To BigDem(15)
- If UBound(BigDem) > 15 Then
- For j16 = LowDem(16) To BigDem(16)
- If UBound(BigDem) > 16 Then
- For j17 = LowDem(17) To BigDem(17)
- If UBound(BigDem) > 17 Then
- For j18 = LowDem(18) To BigDem(18)
- If UBound(BigDem) > 18 Then
- For j19 = LowDem(19) To BigDem(19)
- If UBound(BigDem) > 19 Then
- For j20 = LowDem(20) To BigDem(20)
- If UBound(BigDem) > 20 Then
- For j21 = LowDem(21) To BigDem(21)
- If UBound(BigDem) > 21 Then
- For j22 = LowDem(22) To BigDem(22)
- If UBound(BigDem) > 22 Then
- For j23 = LowDem(23) To BigDem(23)
- If UBound(BigDem) > 23 Then
- For j24 = LowDem(24) To BigDem(24)
- If UBound(BigDem) > 24 Then
- For j25 = LowDem(25) To BigDem(25)
- If UBound(BigDem) > 25 Then
- For j26 = LowDem(26) To BigDem(26)
- If UBound(BigDem) > 26 Then
- For j27 = LowDem(27) To BigDem(27)
- If UBound(BigDem) > 27 Then
- For j28 = LowDem(28) To BigDem(28)
- If UBound(BigDem) > 28 Then
- For j29 = LowDem(29) To BigDem(29)
- If UBound(BigDem) > 29 Then
- For j30 = LowDem(30) To BigDem(30)
- If UBound(BigDem) > 30 Then
- For j31 = LowDem(31) To BigDem(31)
- If UBound(BigDem) > 31 Then
- For j32 = LowDem(32) To BigDem(32)
- If UBound(BigDem) > 32 Then
- For j33 = LowDem(33) To BigDem(33)
- If UBound(BigDem) > 33 Then
- For j34 = LowDem(34) To BigDem(34)
- If UBound(BigDem) > 34 Then
- For j35 = LowDem(35) To BigDem(35)
- If UBound(BigDem) > 35 Then
- For j36 = LowDem(36) To BigDem(36)
- If UBound(BigDem) > 36 Then
- For j37 = LowDem(37) To BigDem(37)
- If UBound(BigDem) > 37 Then
- MsgBox (("Âàñÿ, íå áîëüøå 37 èçìåðåíèé!!!")), vbExclamation
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33, j34, j35, j36, j37) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33, j34, j35, j36, j37)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33, j34, j35, j36) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33, j34, j35, j36)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33, j34, j35) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33, j34, j35)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33, j34) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33, j34)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7, j8) = Arr(j, j1, j2, j3, j4, j5, j6, j7, j8)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6, j7) = Arr(j, j1, j2, j3, j4, j5, j6, j7)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5, j6) = Arr(j, j1, j2, j3, j4, j5, j6)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4, j5) = Arr(j, j1, j2, j3, j4, j5)
- End If
- Next
- Else
- g(j, j1, j2, j3, j4) = Arr(j, j1, j2, j3, j4)
- End If
- Next
- Else
- g(j, j1, j2, j3) = Arr(j, j1, j2, j3)
- End If
- Next
- Else
- g(j, j1, j2) = Arr(j, j1, j2)
- End If
- Next
- Else
- g(j, j1) = Arr(j, j1)
- End If
- Next
- Else
- g(j) = Arr(j)
- End If
- Next
- If UBound(BigDem) = 0 Then ReDim Arr(LowDem(0) To BigDem(0))
- If UBound(BigDem) = 1 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1))
- If UBound(BigDem) = 2 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2))
- If UBound(BigDem) = 3 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3))
- If UBound(BigDem) = 4 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4))
- If UBound(BigDem) = 5 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5))
- If UBound(BigDem) = 6 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6))
- If UBound(BigDem) = 7 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7))
- If UBound(BigDem) = 8 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8))
- If UBound(BigDem) = 9 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9))
- If UBound(BigDem) = 10 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10))
- If UBound(BigDem) = 11 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11))
- If UBound(BigDem) = 12 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12))
- If UBound(BigDem) = 13 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13))
- If UBound(BigDem) = 14 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14))
- If UBound(BigDem) = 15 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15))
- If UBound(BigDem) = 16 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16))
- If UBound(BigDem) = 17 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17))
- If UBound(BigDem) = 18 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18))
- If UBound(BigDem) = 19 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19))
- If UBound(BigDem) = 20 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20))
- If UBound(BigDem) = 21 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21))
- If UBound(BigDem) = 22 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22))
- If UBound(BigDem) = 23 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23))
- If UBound(BigDem) = 24 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24))
- If UBound(BigDem) = 25 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25))
- If UBound(BigDem) = 26 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26))
- If UBound(BigDem) = 27 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27))
- If UBound(BigDem) = 28 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28))
- If UBound(BigDem) = 29 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28), LowDem(29) To BigDem(29))
- If UBound(BigDem) = 30 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28), LowDem(29) To BigDem(29), LowDem(30) To BigDem(30))
- If UBound(BigDem) = 31 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28), LowDem(29) To BigDem(29), LowDem(30) To BigDem(30), LowDem(31) To BigDem(31))
- If UBound(BigDem) = 32 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28), LowDem(29) To BigDem(29), LowDem(30) To BigDem(30), LowDem(31) To BigDem(31), LowDem(32) To BigDem(32))
- If UBound(BigDem) = 33 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28), LowDem(29) To BigDem(29), LowDem(30) To BigDem(30), LowDem(31) To BigDem(31), LowDem(32) To BigDem(32), LowDem(33) To BigDem(33))
- If UBound(BigDem) = 34 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28), LowDem(29) To BigDem(29), LowDem(30) To BigDem(30), LowDem(31) To BigDem(31), LowDem(32) To BigDem(32), LowDem(33) To BigDem(33), LowDem(34) To BigDem(34))
- If UBound(BigDem) = 35 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28), LowDem(29) To BigDem(29), LowDem(30) To BigDem(30), LowDem(31) To BigDem(31), LowDem(32) To BigDem(32), LowDem(33) To BigDem(33), LowDem(34) To BigDem(34), LowDem(35) To BigDem(35))
- If UBound(BigDem) = 36 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28), LowDem(29) To BigDem(29), LowDem(30) To BigDem(30), LowDem(31) To BigDem(31), LowDem(32) To BigDem(32), LowDem(33) To BigDem(33), LowDem(34) To BigDem(34), LowDem(35) To BigDem(35), LowDem(36) To BigDem(36))
- If UBound(BigDem) = 37 Then ReDim Arr(LowDem(0) To BigDem(0), LowDem(1) To BigDem(1), LowDem(2) To BigDem(2), LowDem(3) To BigDem(3), LowDem(4) To BigDem(4), LowDem(5) To BigDem(5), LowDem(6) To BigDem(6), LowDem(7) To BigDem(7), LowDem(8) To BigDem(8), LowDem(9) To BigDem(9), LowDem(10) To BigDem(10), LowDem(11) To BigDem(11), LowDem(12) To BigDem(12), LowDem(13) To BigDem(13), LowDem(14) To BigDem(14), LowDem(15) To BigDem(15), LowDem(16) To BigDem(16), LowDem(17) To BigDem(17), LowDem(18) To BigDem(18), LowDem(19) To BigDem(19), LowDem(20) To BigDem(20), LowDem(21) To BigDem(21), LowDem(22) To BigDem(22), LowDem(23) To BigDem(23), LowDem(24) To BigDem(24), LowDem(25) To BigDem(25), LowDem(26) To BigDem(26), LowDem(27) To BigDem(27), LowDem(28) To BigDem(28), LowDem(29) To BigDem(29), LowDem(30) To BigDem(30), LowDem(31) To BigDem(31), LowDem(32) To BigDem(32), LowDem(33) To BigDem(33), LowDem(34) To BigDem(34), LowDem(35) To BigDem(35), LowDem(36) To BigDem(36), LowDem(37) To BigDem(37))
- For j = LowDem(0) To BigDem(0)
- If UBound(BigDem) > 0 Then
- For j1 = LowDem(1) To BigDem(1)
- If UBound(BigDem) > 1 Then
- For j2 = LowDem(2) To BigDem(2)
- If UBound(BigDem) > 2 Then
- For j3 = LowDem(3) To BigDem(3)
- If UBound(BigDem) > 3 Then
- For j4 = LowDem(4) To BigDem(4)
- If UBound(BigDem) > 4 Then
- For j5 = LowDem(5) To BigDem(5)
- If UBound(BigDem) > 5 Then
- For j6 = LowDem(6) To BigDem(6)
- If UBound(BigDem) > 6 Then
- For j7 = LowDem(7) To BigDem(7)
- If UBound(BigDem) > 7 Then
- For j8 = LowDem(8) To BigDem(8)
- If UBound(BigDem) > 8 Then
- For j9 = LowDem(9) To BigDem(9)
- If UBound(BigDem) > 9 Then
- For j10 = LowDem(10) To BigDem(10)
- If UBound(BigDem) > 10 Then
- For j11 = LowDem(11) To BigDem(11)
- If UBound(BigDem) > 11 Then
- For j12 = LowDem(12) To BigDem(12)
- If UBound(BigDem) > 12 Then
- For j13 = LowDem(13) To BigDem(13)
- If UBound(BigDem) > 13 Then
- For j14 = LowDem(14) To BigDem(14)
- If UBound(BigDem) > 14 Then
- For j15 = LowDem(15) To BigDem(15)
- If UBound(BigDem) > 15 Then
- For j16 = LowDem(16) To BigDem(16)
- If UBound(BigDem) > 16 Then
- For j17 = LowDem(17) To BigDem(17)
- If UBound(BigDem) > 17 Then
- For j18 = LowDem(18) To BigDem(18)
- If UBound(BigDem) > 18 Then
- For j19 = LowDem(19) To BigDem(19)
- If UBound(BigDem) > 19 Then
- For j20 = LowDem(20) To BigDem(20)
- If UBound(BigDem) > 20 Then
- For j21 = LowDem(21) To BigDem(21)
- If UBound(BigDem) > 21 Then
- For j22 = LowDem(22) To BigDem(22)
- If UBound(BigDem) > 22 Then
- For j23 = LowDem(23) To BigDem(23)
- If UBound(BigDem) > 23 Then
- For j24 = LowDem(24) To BigDem(24)
- If UBound(BigDem) > 24 Then
- For j25 = LowDem(25) To BigDem(25)
- If UBound(BigDem) > 25 Then
- For j26 = LowDem(26) To BigDem(26)
- If UBound(BigDem) > 26 Then
- For j27 = LowDem(27) To BigDem(27)
- If UBound(BigDem) > 27 Then
- For j28 = LowDem(28) To BigDem(28)
- If UBound(BigDem) > 28 Then
- For j29 = LowDem(29) To BigDem(29)
- If UBound(BigDem) > 29 Then
- For j30 = LowDem(30) To BigDem(30)
- If UBound(BigDem) > 30 Then
- For j31 = LowDem(31) To BigDem(31)
- If UBound(BigDem) > 31 Then
- For j32 = LowDem(32) To BigDem(32)
- If UBound(BigDem) > 32 Then
- For j33 = LowDem(33) To BigDem(33)
- If UBound(BigDem) > 33 Then
- For j34 = LowDem(34) To BigDem(34)
- If UBound(BigDem) > 34 Then
- For j35 = LowDem(35) To BigDem(35)
- If UBound(BigDem) > 35 Then
- For j36 = LowDem(36) To BigDem(36)
- If UBound(BigDem) > 36 Then
- For j37 = LowDem(37) To BigDem(37)
- If UBound(BigDem) > 37 Then
- MsgBox (("Âàñÿ ÿ ø ñêàçàë íå áîëüøå 37 èçìåðåíèé!!!")), vbExclamation
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33, j34, j35, j36, j37) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33, j34, j35, j36, j37)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33, j34, j35, j36) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33, j34, j35, j36)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33, j34, j35) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33, j34, j35)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33, j34) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33, j34)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32, j33)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31, j32)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30, j31)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29, j30)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28, j29)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27, j28)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26, j27)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25, j26)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24, j25)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23, j24)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22, j23)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21, j22)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20, j21)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19, j20)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18, j19)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17, j18)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16, j17)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15, j16)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14, j15)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13, j14)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12, j13)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11, j12)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10, j11)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9, j10)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8, j9) = g(j, j1, j2, j3, j4, j5, j6, j7, j8, j9)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7, j8) = g(j, j1, j2, j3, j4, j5, j6, j7, j8)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6, j7) = g(j, j1, j2, j3, j4, j5, j6, j7)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5, j6) = g(j, j1, j2, j3, j4, j5, j6)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4, j5) = g(j, j1, j2, j3, j4, j5)
- End If
- Next
- Else
- Arr(j, j1, j2, j3, j4) = g(j, j1, j2, j3, j4)
- End If
- Next
- Else
- Arr(j, j1, j2, j3) = g(j, j1, j2, j3)
- End If
- Next
- Else
- Arr(j, j1, j2) = g(j, j1, j2)
- End If
- Next
- Else
- Arr(j, j1) = g(j, j1)
- End If
- Next
- Else
- Arr(j) = g(j)
- End If
- Next
- ReDim g(0)
- End Function
Ответить
|
Номер ответа: 4 Автор ответа: ilang-ilang
ICQ: 355115304
Вопросов: 5 Ответов: 16
|
Профиль | | #4
|
Добавлено: 20.01.10 13:06
|
сделала так:
- Dim EnergyList() As String
- ReDim EnergyList(3, 0)
- Dim EnergyList2() As String
-
- Dim count_i As Integer
- Dim count_j As Integer
-
- count_i = 0
-
- Open file_name For Input Access Read As #1
-
-
- Do While Not EOF(1)
-
- Line Input #1, str_temp
-
- ReDim Preserve EnergyList(3, count_i)
-
- ......
- count_i = count_i + 1
- Loop
- Close #1
-
-
-
- ReDim EnergyList2(UBound(EnergyList, 2), UBound(EnergyList, 1))
-
- For count_i = 0 To UBound(EnergyList, 1)
-
- For count_j = 0 To UBound(EnergyList, 2)
-
- EnergyList2(count_j, count_i) = EnergyList(count_i, count_j)
-
- Next
- Next
-
Ответить
|
Страница: 1 |
Поиск по форуму