ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¥[Á`ªº°ÝÃD

¥[Á`ªº°ÝÃD

¥»©«³Ì«á¥Ñ chiahuo ©ó 2010-7-8 13:19 ½s¿è

¤p§Ì·Q°ÝÃD¤@¤U
Ãö©ó¥[Á`ªº°ÝÃD
²Ä¤@­Óµ{¦¡¬O
=A1+D1+G1+J1+L1
²Ä¤G­Óµ{¦¡¬O
=SUM(A1,D1,G1,J1,L1)
µª®×³£¤@¼Ë¡A³o¨âµ{¦¡¨º­Ó³B²z³t«×¸û§Ö¡C
¤p§Ì¬Oexcelµ{¦¡ªì¾ÇªÌ¡A½Ð¦h¦h«ü±Ð

Sub 测试()
t = Timer
For i = 1 To 10000
ActiveCell.FormulaR1C1 = _
        "=R[-16]C[-5]+R[-16]C[-4]+R[-16]C[-3]+R[-16]C[-2]+R[-16]C[-1]+R[-16]C" ' ActiveCell.FormulaR1C1 = "=SUM(R[-17]C[-6]:R[-17]C[-1])"
Next
MsgBox Timer - t
End Sub
还¬Osum§Ö¤@点
学习

TOP

¤j¤j§A¯u¼F®`
¤p§Ì¬Oexcelµ{¦¡ªì¾ÇªÌ¡A½Ð¦h¦h«ü±Ð

TOP

        ÀR«ä¦Û¦b : ¤H­nª¾ºÖ¡B±¤ºÖ¡B¦A³yºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD