Hello everyone,

I Have a little problem, with the macro I am running finally it selects a row, inserts a row at that point and then i want it to insert some excel formulas in the cell.

in example:

5 10 A1+A2

now when I use 

.Range("D" & rij).FormulaR1C1 = "=datum(jaar(B" & rij & ");maand(B" & rij & ")+1;dag(B" & rij & "))"
.Range("F" & rij).FormulaR1C1 = "=D" & rij & "-7"
.Range("H" & rij).FormulaR1C1 = "=als(vandaag()>=F" & rij & ";x; )"

it goes absolute ape, the first input generates an error, upon ignoring the first the second does insert and does give the right formula but it looks like this ='d855'-7 so excel doesnt see it as a proper formula. And the last formula has the problem that it has text insertions, so more "" then vba can handle, I can work around this by inserting the text in designated excel sheet, but I dont understand where the first error is coming from.

tia
frank


I have a dutch excel

datum = date
jaar = year
rij = the row number (vba number)
maand = month
dag = day
als = if
vandaag = today