字符串连接，求助，谢谢！！！

ahbc123 · 发表于 2023-3-1 12:54

还请帮助看看，红色部分为啥改成变量，就不对了，谢谢
=IF(E44<>"",IF(COUNTIF(B44,"*"&E44&"*"),"√","×"),"")

我想把"*"&E44&"*" 里的44改成变量 [M1]+5，下面语句出错。

Sheets("考试").Range("F" & Sheets("考试").[M1] + 5).Resize(Sheets("考试").[M1]).Formula = "=IF(E" & [M1] + 5 & "<>"""" ,IF(COUNTIF(B" & [M1] + 5 & ",""*""& "E" & [M1] + 5 &""*""),""√"",""×""),"""")"

grf1973 · 发表于 2023-3-1 14:49

是不是因为[M1]没指定工作表。
先令t=Sheets("考试").[M1] + 5
再试试
Sheets("考试").Range("F" & t).Resize(t-5).Formula = "=IF(E" & t & "<>"""" ,IF(COUNTIF(B" & t & ",""*""& "E" & t &""*""),""√"",""×""),"""")"

半百 · 发表于 2023-3-1 15:10

= "=IF(E" & [M1] + 5 & "<>"""" ,IF(COUNTIF(B" & [M1] + 5 & ",""*""&E" & [M1] + 5 & "&""*""),""√"",""×""),"""")"

zldccmx · 发表于 2023-3-1 15:11

ahbc123 · 发表于 2023-3-1 15:21

半百发表于 2023-3-1 15:10
= "=IF(E" & [M1] + 5 & """"" ,IF(COUNTIF(B" & [M1] + 5 & ",""*""&E" & [M1] + 5 & "&""*""),""√"","" ...

谢谢！！！

		自动登录	找回密码
密码			免费注册

[求助] 字符串连接，求助，谢谢！！！

评分

评分

评分