Quote Originally Posted by enjam View Post
Thank you Paul, that code works just as intended. I'm applying on a range that's quite a bit longer (280,000 rows); it takes a while, but does the job
Sorry, if I had known you were talking about 280K entries, I would have used arrays (like I think P45cal did)

My fault was using a IMHO more straight-forward approach that I thought would be easier for you to integrate

If it still seems too slow, come on back, but p45cal's and snb's should work fine