I could use a hand with this one.

[The_Rookie]

Ill give it a try but when i use the

For i=1 To NumberofRowsToCheck
    For j=1 to NumberOfColumnsToCheck
        Set aCell = aWorksheet.Cells(i, j)

Do i get rid of this all together?

Do While aWorksheet.Cells(r1, c1 + 2) <> ""
        Set aCell = aWorksheet.Cells(r1, c1 + 2)

And for the rows to check I just want to check the whole sheet so would i put in there 65536?


Thanks for all your paitence help fellas....