Not able to retrieve data from array. Please help.
My code is as under:
Sub test()
Dim arr_data(1 To 100000, 1 To 30, 1 To 10) As Variant
Dim at, at1, col_t, row_t As Integer
Dim col_v, row_v, data_v As Variant
For at = 2 To row_t
For at1 = 2 To col_t
col_v = Worksheets("Sch_P1").Cells(at, 1)
row_v = Worksheets("Sch_P1").Cells(1, at1)
arr_data(row_v, col_v, 1) = Worksheets("Sch_P1").Cells(at, at1)
arr_data(row_v, col_v, 2) = Worksheets("Sch_P2").Cells(at, at1)
arr_data(row_v, col_v, 3) = Worksheets("Sch_P3").Cells(at, at1)
arr_data(row_v, col_v, 4) = Worksheets("Sch_B1").Cells(at, at1)
arr_data(row_v, col_v, 5) = Worksheets("Sch_B2").Cells(at, at1)
arr_data(row_v, col_v, 6) = Worksheets("Sch_B3").Cells(at, at1)
arr_data(row_v, col_v, 7) = Worksheets("Sch_B4").Cells(at, at1)
Next at1
MsgBox arr_data(row_v, col_v, 1)
Next at
col_v = (Worksheets("Sch_P1").Cells(1, 5)
row_v = Worksheets("Sch_P1").Cells(5, 1)
MsgBox arr_data(row_v, col_v, 1)
End Sub
I am beginner...
Posting for the first time...
My code is as under:
Sub test()
Dim arr_data(1 To 100000, 1 To 30, 1 To 10) As Variant
Dim at, at1, col_t, row_t As Integer
Dim col_v, row_v, data_v As Variant
For at = 2 To row_t
For at1 = 2 To col_t
col_v = Worksheets("Sch_P1").Cells(at, 1)
row_v = Worksheets("Sch_P1").Cells(1, at1)
arr_data(row_v, col_v, 1) = Worksheets("Sch_P1").Cells(at, at1)
arr_data(row_v, col_v, 2) = Worksheets("Sch_P2").Cells(at, at1)
arr_data(row_v, col_v, 3) = Worksheets("Sch_P3").Cells(at, at1)
arr_data(row_v, col_v, 4) = Worksheets("Sch_B1").Cells(at, at1)
arr_data(row_v, col_v, 5) = Worksheets("Sch_B2").Cells(at, at1)
arr_data(row_v, col_v, 6) = Worksheets("Sch_B3").Cells(at, at1)
arr_data(row_v, col_v, 7) = Worksheets("Sch_B4").Cells(at, at1)
Next at1
MsgBox arr_data(row_v, col_v, 1)
Next at
col_v = (Worksheets("Sch_P1").Cells(1, 5)
row_v = Worksheets("Sch_P1").Cells(5, 1)
MsgBox arr_data(row_v, col_v, 1)
End Sub
I am beginner...
Posting for the first time...