Doing an assignment for Uni, lecturer didn’t provide us with any teaching on vba.. have this code written out and when i run it it’s only giving me back the first row of each of my ranges, i can’t seem to move it down the row.
What code? I don't see any code in your post.
Sub Table2()What code? I don't see any code in your post.
Are x, y, and Z supposed to be ranges or values?x = Range("M16:M26")
y = Range("N16:N26")
Z = Range("O16:O26")
Cells(28 + i, "M") = x
Cells(28 + i, "N") = y
Cells(28 + i, "O") = Z
Set x = Range("M16:M26")