Andreas Palm (HP C&I .NET)
Guest
Using DATE in VBA, gives error
Range("L" & c).Select
With Selection
.FormulaR1C1 = "DATE(YEAR(""" & t & """);" & "MONTH(""" & t & """)+" & b & " ;" & "DAY(""" & t & """))"
End With
What I try to do is this
.FormulaR1C1 = "=DATE(YEAR(""" & t & """);" & "MONTH(""" & t & """)+" & b & " ;" & "DAY(""" & t & """))"
However as soon as I put "=" in the code I get an error. Without the "=" the cells get filled with this:
DATE(YEAR("01.01.2005");MONTH("01.01.2005")+2 ;DAY("01.01.2005"))
if in the cell I put the "=" in front of this text I get exactly what I want => 01.03.2005
So why do I get an error in the code, if when I change the code later manually the formula is correct.
best regards
andreas
Bookmarks