excel vba 按条件选中多行

Question

判断A列的每个单元格，如A2，A6的内容是yes，就将这两行同时选中，谢谢了

Answer 1

dim rng as range
dim maxRow as integer
maxRow = cells(1,1).end(xlup).row
for each rng in activesheet.range("A1:A" & maxRow)
if rng.value = "yes" then
rng.select
end if
next本回答被提问者采纳