Hi,

I am trying to modify a VBA code in order to get the output from the code pasted in columns N, R and V instead of the original, and adjacent, columns N, O and P in a worksheet named “ows”.

There are a few lines in the code that I need help to modify:

ows.Range("N9").Resize(ows.Rows.Count - 8, 3) = ""
ows.Range("N9").Resize(trecords, 3) = arr
.Range("N9").Resize(lastrow, 3) = ""
.Range("N9").Resize(lastrow, 3) = arr3
I am quite inexperienced with VBA and tried the modifications below, but got Syntax Error:


ows.Range("N9").Resize(ows.Rows.Count - 8, 1) + ows.Range("R9").Resize(ows.Rows.Count - 8, 1) + ows.Range("V9").Resize(ows.Rows.Count - 8, 1) = ""
ows.Range("N9").Resize(trecords, 1) + ows.Range("R9").Resize(trecords, 1) + ows.Range("V9").Resize(trecords, 1) = arr
.Range("N9").Resize(lastrow, 1) + .Range("R9").Resize(lastrow, 1) + .Range("V9").Resize(lastrow, 1) = ""
.Range("N9").Resize(lastrow, 1) + .Range("R9").Resize(lastrow, 1) + .Range("V9").Resize(lastrow, 1) = arr3
Any suggestions?

Regards,
Marbleking