A = "O11"
G = "M11"
Z = "L11"
Q = "N11"
MC = "P11"
[Q11] = "=(" & Q & "+" & G & ")*" & A & "+(1/3*" & MC & "+2/3*" & Z & ")"
[R11] = "=(" & Q & "+" & G & ")*" & A & "+(1/3*" & Z & "+2/3*" & MC & ")"追问
G = "M11"
Z = "L11"
Q = "N11"
MC = "P11"
[Q11] = "=(" & Q & "+" & G & ")*" & A & "+(1/3*" & MC & "+2/3*" & Z & ")"
[R11] = "=(" & Q & "+" & G & ")*" & A & "+(1/3*" & Z & "+2/3*" & MC & ")"追问
我为什么错了？我觉得我也没错啊
追答你自己对比下结果有什么不同不就知道了
你把这些变量都放双引号内，表示是字符而不是变量，也就是你看到代码里面双引号的是什么，赋值后就是什么。
温馨提示：答案为网友推荐，仅供参考
相似回答