WaterSprite
Technical User
[Dim x As Date, xx As Integer]
[x = Cells(1, 1).Value]
[xx = 12]
[Cells(2, 1).FormulaR1C1 = "=Edate(R1C,R1C2)"]
Can I use "Edate" with variables, as in the line of code below.
If I could at least figure out how to use a variable for 12 it would help a lot.
[Cells(2, 1).FormulaR1C1 = "=Edate(x,xx)"]
Thanks for any help.
[x = Cells(1, 1).Value]
[xx = 12]
[Cells(2, 1).FormulaR1C1 = "=Edate(R1C,R1C2)"]
Can I use "Edate" with variables, as in the line of code below.
If I could at least figure out how to use a variable for 12 it would help a lot.
[Cells(2, 1).FormulaR1C1 = "=Edate(x,xx)"]
Thanks for any help.