Thanks to all for your replies - I am very grateful.
Alok's reply interests me - if it easier to enter it using a simple
formula then I would consider it. Being a bit of a newbie to Excel VBA
I thought the solution was to do it via VBA but it looks like I have
taken a long cut for a short cut!
If someone can supply the forumla solution (or give me advice on how it
could be achieved) I would also be very grateful

Best Regards
Tony