Merging two tables

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top