Hi tony,

Your translation is perfect, that is exactly what it is supposed to do. Now I am going to try to explain what it does.

upon selecting an interval in a combobox (monthly, quarterly, yearly, etc) it inserts a row on the first blank cell under the header monthly, quarterly, etc. So you get a clean row for the inserted task. I then insert the name of task (via an inputbox) in Column A in the newly inserted row (say row 58), then it inserts today's date in B58, a certain number in C58, now it comes to the insertion of the 3 formulas, the weird thing is that it thinks that formula 1 and 3 are text and it gives a Name error, formula 2 it inserts just fine.

To solve the name error I can just edit the formula (pressing F2) and then hit enter, that it is enough. Now is there a VBA method to recalculate the cell or something similar, because that might work.

[EDIT]

Ok guys I solved it, stupid language problem, since VBA is in english and my excel is in dutch it does weird things every now and then. I changed the formulas to their english twins and now it works beautifully, when I return to excel it even translated the formulas into dutch!
This also explained why I was the only one encountering these problems.
Thanx for your help.
frank

frank


[/EDIT]