Date issue

[alexandro88]

Dim LValue as String
LValue = Format(Cells(1, 14), "d - mmm - yy")

What problem with my code? My variable Lvalue not able to detect the date.

[macropod]

Try:
LValue = Format(Cells(1, 14).Value, "d - mmm - yy")