|
Cells(a, 7) = "=(LEFT(" & Range("D" & a) & ",FIND(""*""," & Range("D" & a) & ")-1)+RIGHT(" & Range("D" & a) & ",LEN(" & Range("D" & a) & ")-FIND(""*""," & Range("D" & a) & ")))*2/10000"
我想计算 600*600这种数据的 周长和面积,用VBA该怎么写呢 ?求大神指点
上面计算周长了 可是显示错误
600*600相当于 长度*宽度
本帖最后由 zjdh 于 2013-3-2 17:53 编辑
面积(平方米)
Cells(a, 7) = "=LEFT(R" & a & "C4,LEN(R" & a & "C4)-FIND(""*"",R" & a & "C4))*RIGHT(R" & a & "C4,LEN(R" & a & "C4)-FIND(""*"",R" & a & "C4))/10000"
周长(米)
Cells(a, 8) = "=(LEFT(R" & a & "C4,LEN(R" & a & "C4)-FIND(""*"",R" & a & "C4))+RIGHT(R" & a & "C4,LEN(R" & a & "C4)-FIND(""*"",R" & a & "C4)))*2/100"
|
|