预期:语句结束

Question

需要以下代码的帮助： 由于 " 引号，在第 1 行中出现错误。

Range("L2").Formula = "=IF(D2="Demand Open",Networkdays(U2,Today())," - ")"
Set R = Range("B2", Range("B" & Rows.Count).End(xlUp))
Set R = Intersect(R.EntireRow, Range("L:L"))
R.FillDown
Range("L:L").Value = Range("L:L").Value

Answer 1

应该是双""

Range("L2").Formula = "=IF(D2=""Demand Open"",Networkdays(U2,Today()),"" - "")"