Glad to hear you got it to work!
And thanks for posting back

As you can see from the previous post,
I was trying to input the date into cell H1 ...

Yes, you did. Overlooked this earlier, apologies
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Big Rick" wrote in message
...
I did finally get Bob' code to work by pre formatting the cells. As you
can
see from the previous post, I was trying to input the date into cell H1.
Thanks for the suggestions as to why it didnt work. Many thanks to Bob
also.

Many Regards
--
Big Rick