vba问题？
答案:1 悬赏:70 手机版
解决时间 2021-04-21 12:50
- 提问者网友：寂寞梧桐
- 2021-04-20 23:55
在一个工作表中，从第8行至1800行中，如果 I 至 P 列中的每一行为空，Q列所对应行中的单元格为零，此行隐藏。此代码如何正确写出，请VBA大侠帮忙写一下，谢谢！！
最佳答案
- 五星知识达人网友：青尢
- 2021-04-21 00:46
dim i as integer
for i = 8 to 1800
if cells(i,9) = "" and cells(i,10) = "" and cells(i,11) = "" and cells(i,12) = "" and cells(i,13) = "" and cells(i,14) = "" and cells(i,15) = "" and cells(i,16) = "" and cells(i,17) = 0 then rows(i).hidden = true
next i
for i = 8 to 1800
if cells(i,9) = "" and cells(i,10) = "" and cells(i,11) = "" and cells(i,12) = "" and cells(i,13) = "" and cells(i,14) = "" and cells(i,15) = "" and cells(i,16) = "" and cells(i,17) = 0 then rows(i).hidden = true
next i
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯