ExcelBanter - multidimensional array

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - multidimensional array (https://www.excelbanter.com/excel-programming/396622-multidimensional-array.html)

Peter[_61_]

multidimensional array

What am I doing wrong?

For lfor = LBound(Merch(lfor, 0)) To UBound(Merch(lfor, 1))
Merch(lfor, 0) = Cells(lfor, 1)
Merch(lfor, 1) = Cells(lfor, 2)
Next lfor

Tom Ogilvy

multidimensional array

i = 1
For lfor = LBound(Merch, 1) To UBound(Merch, 1)
Merch(lfor, 0) = Cells(i, 1)
Merch(lfor, 1) = Cells(i, 2)
i = i + 1
Next lfor

--
Regards,
Tom Ogilvy

"Peter" wrote:

What am I doing wrong?

For lfor = LBound(Merch(lfor, 0)) To UBound(Merch(lfor, 1))
Merch(lfor, 0) = Cells(lfor, 1)
Merch(lfor, 1) = Cells(lfor, 2)
Next lfor

All times are GMT +1. The time now is 09:43 PM.