代码需要在指定的表格区域生效
生效区域为B9:J17
function Application_SheetSelectionChange()
{
for(var ii=9;ii<=17;ii++)
{
switch (true)
{
case Cells(ii,2).Value2 != undefined && Cells(ii,4).Value2 > 0 && Cells(ii,5).Value2 > 0:
Cells(ii,8).Value2=Cells(ii,4).Value2*Cells(ii,5).Value2;
break;
default:
Cells(ii,8).Value2="";
break;
}
switch (true)
{
case Cells(ii,2).Value2 != undefined && Cells(ii,9).Value2 > 0 && Cells(ii,10).Value2 > 0:
Cells(ii,11).Value2=Cells(ii,9).Value2*Cells(ii,10).Value2;
break;
default:
Cells(ii,11).Value2="";
break;
}
}
}