if e.offset(1,0)=arrVal(0) then
msg( arrVal(0) & " exists already")
In the above code arrVal(0) is a date I am getting it in message box as
12/5/2005.
I want this as 05-DEC-2005.What additional lines I ahve to insert to get the
result what I need?.