Dynamic Ranges - Create Using VBA as looping through Sheets

If Trim((x(i, 7))) = vbNullString Then

Simply testing if column G is nil. It is one of the condition for that particular task.

The reason forgetting the error is this line.

 x = ws.Range("A1:E" & ws.Cells.Find("*", , , , xlByRows, xlPrevious).Row)

The max column loop the X array can take is 5, which is E. If you change it to G, you would not get an error.

Thanks for the explanation.
I didn't think to look back in the code to find the problem.
A very useful bit of information.

Thanks again.