Adding months to a date in a vba formula

[Jos66]

Hello,

I am having the following problem in Excel (2013):

I am trying to add up months to a date, using the function "Zelfde.dag" (this is in Dutch, the function in English is EDATE() I think).

This is no problem as long as one adds this formula directly into the cells in Excel. However, I am trying to program the same thing into a vba module, using the following syntax : activecell.FormulaR1C1 = "=ZELFDE.DAG(RC[-2],RC[-1])". So this formula added to the activecell (in my case in cell D7) renders the new date based on adding the data in cells B7 and C7. B7 is a date, C7 is a number between 1 and 12. I then make the sub work by means of a button specially made for this purpose. This results, however, in an error #name? .
What could be wrong with this ? Is this a bug in vba ?
Thanks in advance.

[mjr veverka]

Use the english function names in the vba editor:

Please Login or Register  to view this content.

What is the effect ?

[Jos66]

Hi PV,

It worked. Thanks a lot.