|
楼主 |
发表于 2021-6-18 11:59
|
显示全部楼层
还有个问题,还得麻烦您一下,我用以下代码执行出来的结果跟用公式算出来的结果不同,是代码哪里不对吗? Dim ary As Long
ary = Range("a65536").End(xlUp).Row
For i = 3 To ary
Cells(i, 10) = Cells(i, 8) - Cells(i, 7) * 24 这行公式 =(H2-G2)*24
Cells(i, 11) = Cells(i, 9) - Cells(i, 8) * 24 这行公式=(I2-H2)*24
Next
用以下代码执行后会带出公式,
Dim ary As Long
ary = Range("a65536").End(xlUp).Row
For i = 3 To ary
Cells(i, 10) = "=(RC[-2]-RC[-3])*24"
Cells(i, 11) = "=(RC[-2]-RC[-3])*24"
Next
|
|