I'm really sorry for the late reply, my uncle passed away and I had to put everything on hold to deal with that. I tried your suggestion bu it didn't do anything, it's still taking about two minutes to run to code. I don't have any blank cells in that column. Thanks for providing the answer though. Let's see if there's a way out of the long processing time