Hi Fred,
You can use TEXT() function or set cell format. See
http://support.microsoft.com/kb/264372 for format codes
=TEXT(B17,"mmmm")
.NumberFormat = "mmmm"
>
>Sorry for the silence, I had to attend to something else. I agree with you with the ease of using Borders instead of Lines and that's what I am have decided to be using. Thanks for the piece of code on Addline() I may need it in future.
>
>Before I leave, which is the Excel Function equivalent of CMONTH() given a Date cell ?
--sb--