P
Przemek
Hi, I've got following problem:
I have to tables, one is copy of another one.
aa ab ac ad
ba bb bc bd
ca cb cc cd
da db dc dd
I'm looping for each cell in table A and table B and summing up their
values:
For Each cellA In os.Cells
For Each cellb In os.Cells
result = cell.Value + cellb.Value
' address of cellResult
cellResult.Value = wynik
Next
Next
I don't know how to write a statement, which would create the table
with results (moved cellResult address accordingly). In example given
above i'll get 256 result, in real I'll have tables 11x11. Anyone
helps?
TIA
Przemek
I have to tables, one is copy of another one.
aa ab ac ad
ba bb bc bd
ca cb cc cd
da db dc dd
I'm looping for each cell in table A and table B and summing up their
values:
For Each cellA In os.Cells
For Each cellb In os.Cells
result = cell.Value + cellb.Value
' address of cellResult
cellResult.Value = wynik
Next
Next
I don't know how to write a statement, which would create the table
with results (moved cellResult address accordingly). In example given
above i'll get 256 result, in real I'll have tables 11x11. Anyone
helps?
TIA
Przemek