EXCEL代码帮忙改成VBA命令,点击按钮自动遍历G列,循环判断省份后执行相应...答:if vartype(arr(i,5))=vbdouble then '只处理E列为数值的 for j=2 to ubound(std)if std(j,1)=arr(i,7) then if std(j,2)<=arr(i,5) and std(j,3)>=arr(i,5) then cells(i,6) = std(j,4) + std(j,5) * Application.WorksheetFunction.RoundUp(arr(i,5)-1,0)exit ...