boyxin
Members actively
- Tham gia
- 10/3/08
- Bài viết
- 1,664
- Được thích
- 2,335
Code bài 8
Dùng đoạn code này (Test tại máy của em 0.375") các bác kiểm tra lại giúpTương tự bài trên, chỉ làm 3.125 dòng, sau đó:
Range("A3126:F15625").FormulaR1C1 = "=R[-3125]C+200000"
Range("G3126:J12500").FormulaR1C1 = "=R[-3125]C+200000"
Range("A3126:j15625") = Range("A3126:j15625").Value
Giảm còn 1/2 thời gian
PHP:
Sub Bai8_03()
Dim Rng As Variant, iR As Long
Dim n2 As Long, n3 As Long, n4 As Long, n5 As Long, n6 As Long
[A1:J15625].Clear
Rng = [A1:A3125]
[m1] = Timer
With Application
.DisplayAlerts = False
.ScreenUpdating = False
.Calculation = xlCalculationManual
For n2 = 1 To 9 Step 2
For n3 = 1 To 9 Step 2
For n4 = 0 To 9 Step 2
For n5 = 0 To 9 Step 2
For n6 = 0 To 9 Step 2
iR = iR + 1
Rng(iR, 1) = 1 & n2 & n3 & n4 & n5 & n6
Next: Next: Next: Next: Next: iR = 0
[A1:A3125] = Rng
[A3126:A15625].FormulaR1C1 = "=R[-3125]C+200000"
[B1:B15625].FormulaR1C1 = "=RC1 - 900"
[C1:C15625].FormulaR1C1 = "=RC1 - 990"
[D1:D15625].FormulaR1C1 = "=RC1 - 9900"
[E1:E15625].FormulaR1C1 = "=RC1 - 10890"
[F1:F15625].FormulaR1C1 = "=RC1 - 9990"
[G1:G12500].FormulaR1C1 = "=RC1 + 99110"
[H1:H12500].FormulaR1C1 = "=RC1 + 100010"
[I1:I12500].FormulaR1C1 = "=RC1 + 100100"
[J1:J12500].FormulaR1C1 = "=RC1 + 90110"
[A1:J15625] = [A1:J15625].Value
[m2] = Timer: [m3] = [m2] - [m1]
[m4] = [A1:J15625].SpecialCells(2, 1).Count
.Calculation = xlCalculationAutomatic
.ScreenUpdating = True
.DisplayAlerts = True
End With
End Sub
Lần chỉnh sửa cuối: