Loop runs into subscript out of range in the last row?

I have copied it over into another workbook and in that one, it works like a charm.. could it be because I already have another scripting dictionary in my original file?

Just a lucky" guess.. It might have to do with the Else.. part of the if statement.

lets say you have 50 in the databody range at the start of the loop so the loop is set for 1 to 50 and at row 33 the Else statement is excecuted. then it deletes row 33 resulting in only 49 rows left in databodyrange but because the for loop was set to 50 at the start. there is now no longer a row 50 in the databody range.

Yeah update on this, it actually does the job, only instead of just finishing it runs into the error? ( I only just realized this because some last names had spaces beside them so they stayed and I still had name duplicates by the looks of it)

It probably is what you are saying.. but how does one fix it, and why wasn't it a problem in my other worksheet, where it does the same job?

AAAH because it is stepping backwards there..