I can’t see the reason I am getting an error message Else If without If. Does it have something to do with the Msgbox? The problem is I had EXIT SUB after the first IF statement and then a regulur if statement next which never got to the next if statement. When I close out the msgbox it would start the next if isnumeric… and run it which merges the wrong rows that the msgbox if statement warned against.