Depending on the preceeding code, i will represent a line number. For
example - 5

If i = 5 the code is basically copying the value in cell B5 and placing
it into cells AS4

Not sure what the resize is doing, can't see what changes its actually
making!