|
Cells(banklastrow, "f").FormulaR1C1 = "=RC[-1]/(datediff("d",RC[-2],RC[-3])/30)"
Cells(banklastrow, "g").FormulaR1C1 = "=RC[-1]*12"
1032446692 发表于 2013-5-20 00:08
你这句是有问题的
Cells(banklastrow, "f").FormulaR1C1 = "=RC[-1]/(datediff("d",RC[-2],RC[-3])/30)"
...
Cells(banklastrow, "f").FormulaR1C1 = "=RC[-1]/(datedif(RC[-2],RC[-3],""d"")/30)"
3个问题
1 datediff 多了个字符 f
2 datedif3个参数顺序错了,应该是 开始日期,结束日期,参数类型字符
3 引号内的引号,要重复用2次。
|
|