2,463
社区成员
发帖
与我相关
我的任务
分享
sub test
dim Rngs as range,Rng as range
set rngs=sheet1.rrange('a3:h33")'''
for each rng in rngs
select case val(rng.value)
case 70 to 79
rng.value=2.5
case 80 to 89
rng.value=3
end select
next
end sub