想在sheet(1,1)设置公式”=CONCATENATE(TEXT(A2,'& "ddd" &'),TEXT(A2,'& "AAAA" &')),
代码为:
sheet(1,1).formula = "=CONCATENATE(TEXT(A2,'& "ddd" &'),TEXT(A2,'& "AAAA" &'))"
总是提示应为结束语句,咋回事?请老师指教!