Дорогие други, подскажите, как оптимизировать код?
Код |
---|
IF ...... THEN Select Case Sheets("out").Cells(i, 3).Value Case 1 lvl1 = Sheets("out").Cells(i, 3).Value Case 2 lvl2 = Sheets("out").Cells(i, 3).Value Case 3 lvl3 = Sheets("out").Cells(i, 3).Value Case 4 lvl4 = Sheets("out").Cells(i, 3).Value Case 5 lvl5 = Sheets("out").Cells(i, 3).Value Case 6 lvl6 = Sheets("out").Cells(i, 3).Value Case 7 lvl7 = Sheets("out").Cells(i, 3).Value Case 8 lvl8 = Sheets("out").Cells(i, 3).Value Case 9 lvl9 = Sheets("out").Cells(i, 3).Value End Select ELSE Sheets("in").Cells(k, 2).Value = lvl1 Sheets("in").Cells(k, 3).Value = lvl2 Sheets("in").Cells(k, 4).Value = lvl3 Sheets("in").Cells(k, 5).Value = lvl4 Sheets("in").Cells(k, 6).Value = lvl5 Sheets("in").Cells(k, 7).Value = lvl6 Sheets("in").Cells(k, 8).Value = lvl7 Sheets("in").Cells(k, 9).Value = lvl8 Sheets("in").Cells(k, 10).Value = lvl9 END IF |