---------------------------
错误
---------------------------
编译错误:应为语句结束。
错误代码：If Sheet(n, whcode).Value Like "*成品*" AndAlso Sheet(n, whcode).Value
not Like "*半*" AndAlso Sheet(n, whcode).Value
not Like "*退*" Then
---------------------------
确定
---------------------------
把两个not 去掉就对了，为啥？如何修改？
[此贴子已经被作者于2024/3/7 14:33:04编辑过]
If Sheet(n, whcode).Value Like "*成品*" AndAlso not (Sheet(n, whcode).Value Like "*半*") AndAlso ..........