vba问题:for each c in range(“t1:es1”) if cells(“a1:vba问题:for each c in range(“t1:es1”)if cells(“a1:h1”).value=c .value then.请问if语句有什么错误,我想表达就是a1:h1里面的每个单元格
来源:学生作业帮助网 编辑:作业帮 时间:2024/11/28 02:14:46
vba问题:for each c in range(“t1:es1”) if cells(“a1:vba问题:for each c in range(“t1:es1”)if cells(“a1:h1”).value=c .value then.请问if语句有什么错误,我想表达就是a1:h1里面的每个单元格
vba问题:for each c in range(“t1:es1”) if cells(“a1:
vba问题:for each c in range(“t1:es1”)
if cells(“a1:h1”).value=c .value then.请问if语句有什么错误,我想表达就是a1:h1里面的每个单元格单元格都和c比较一下.
vba问题:for each c in range(“t1:es1”) if cells(“a1:vba问题:for each c in range(“t1:es1”)if cells(“a1:h1”).value=c .value then.请问if语句有什么错误,我想表达就是a1:h1里面的每个单元格
不存在cells("a1:h1")这种引用方法.
dim c as range,cc as range,myboo as boolean
for each c in range("t1:es1")
myboo = false
for each cc in range("a1:h1").cells
if cc.valuec.value then
myboo=true
exit for
end if
next
if myboo then msgbox cc.address & "" & c.address
next