Rudi I'd like to shake your hand.

I use the F8 key to run through the code and get good results, I change the ref from A1 to other cells where I have names and still get the correct results.

I will mark this post as solved as the original question has now been solved.

Now I will try and figure out where to insert and modify "your" code into my existing macro/module and then more rigorous testing.



Watch this space

Once again, thank you for ALL your help.

Enjoy the rest of the weekend.

Keith