Thanks for the help so far, but I think I've taken on a larger project than I first thought, I have tried to implement the above code change with no luck. I am hoping you can have a look at the attached sample and point me in the right direction. Book1 Macro Required.xlsm

I have the current Macro running but you will see that it dose not work with a formula updating it.