It appeared to me the problem was that Excel VBA was treating your dates as
US format. when you use the value property with a cell containing a date it
gets translated as a date string and gets misinterpreted (if the day and
month values are ambiguous). Value2 returns the date serial number.

To demo from the immediate window:

? activeCell.Value
1/21/03
? activeCell.Value2
37642

--
Regards,
Tom Ogilvy


Soniya wrote in message
...
Thanks Bob, Tom and KeepITCool


Now it works fine..

I used Toms Value2 option..

why Value2 ?
its new for me..


Regards,

Soniya


-----Original Message-----
soniya,
send me your book and i'll have a look.
address below

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Soniya" wrote:


Still the Same : - (

.