Kenneth thanks I get a compile error when I use Date just like when I use the Format. I must be missing some libraries in my VBA even though I can see them in my object browser.

Thanks
Tom