Excel执行宏的时候出错，说我语法错误，请问是哪错了。

答案:2 悬赏:0 手机版

解决时间 2021-02-22 00:55

提问者网友：却不属于对方
2021-02-21 14:02

Excel执行宏的时候出错，说我语法错误，请问是哪错了。ActiveCell.FormulaR1C1 = _
"=IF(RC[-1]=""不锈钢"",""不锈钢"",IF(RC[-42]=""定襄"",""寄售"",IF(AND(RC[-42]=""太原"",RC[-29]=""X80M""),""前移"",IF(AND(RC[-42]=""济南"",LEN(RC[-18])>LEN(SUBSTITUTE(RC[-18],""前移"",""""))),""前移"",IF(AND(RC[-42]=""济南"",LEN(RC[-18])>LEN(SUBSTITUTE(RC[-18],""撮合"",""""))),""前移"",IF(AND(RC[-42]=""天津"",RC[-32]=""F""),""前移"",IF(RC[-30]=""硅钢"",""前移"",IF(RC[-39]=""6340"",""寄售"",IF(RC[-39]="""& _
""寄售"",IF(RC[-39]=""6360"",""寄售"",""前移""))))))))))"

最佳答案

五星知识达人网友：十年萤火照君眠
2021-02-21 14:55

正确的语句：
ActiveCell.FormulaR1C1 = "=IF(RC[-1]=""不锈钢"",""不锈钢"",IF(RC[-42]=""定襄"",""寄售"",IF(AND(RC[-42]=""太原"",RC[-29]=""X80M""),""前移"",IF(AND(RC[-42]=""济南"",LEN(RC[-18])>LEN(SUBSTITUTE(RC[-18],""前移"",""""))),""前移"",IF(AND(RC[-42]=""济南"",LEN(RC[-18])>LEN(SUBSTITUTE(RC[-18],""撮合"",""""))),""前移"",IF(AND(RC[-42]=""天津"",RC[-32]=""F""),""前移"",IF(RC[-30]=""硅钢"",""前移"",IF(RC[-39]=""6340"",""寄售"",IF(RC[-39]=""寄售"",IF(RC[-39]=""6360"",""寄售"",""前移""))))))))))"我选中CK1，执行后结果为：
=IF(CJ1="不锈钢","不锈钢",IF(AU1="定襄","寄售",IF(AND(AU1="太原",BH1="X80M"),"前移",IF(AND(AU1="济南",LEN(BS1)>LEN(SUBSTITUTE(BS1,"前移",""))),"前移",IF(AND(AU1="济南",LEN(BS1)>LEN(SUBSTITUTE(BS1,"撮合",""))),"前移",IF(AND(AU1="天津",BE1="F"),"前移",IF(BG1="硅钢","前移",IF(AX1="6340","寄售",IF(AX1="寄售",IF(AX1="6360","寄售","前移"))))))))))

全部回答

1楼网友：轻熟杀无赦
2021-02-21 16:35

从你的描述看，初步判断：中了宏病毒！你去百度的“网页”项搜索：宏病毒专杀|免疫（cleanmacro) 下载安装去试一试吧！！！

我要举报

如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！