Hi,

I have some difficulties with this code:



code:
--------------------------------------------------------------------------------

Columns("L:L").Select
Selection.NumberFormat = "m/d/yyyy;@"

//Compte is the number of cells i have in a column
colonneA = "A2:A" & (Compte + 1)
indice = 2
Sheets("SOURCE").Select
Range(colonneA).Select
For Each cell In Application.Selection
            adrL = "L" & indice
            ladate = Range("adrL").Value //here is my problem, Range("adrL").Value is not a date...
            Mois = Month(ladate)
            ...
Next

--------------------------------------------------------------------------------




Range("adrL").Value is not a date. I don't understand because I set it before...

Does somebody can help me?


TranceFuZion
Booking: [email protected]
www.trancefuzion.com

Inline DJ
www.inlinedj.com

Ok i found my error...

Thanks!

TranceFuZion
Booking: [email protected]
www.trancefuzion.com

Inline DJ
www.inlinedj.com

hello,

Delete the quotes in ladate = Range("adrL").Value
change is now ladate = Range(adrL).Value

Bey