記述による処理速度の違い｜VBA技術解説

Sub Test11() Dim i As Long, j As Long, k As Long Dim v1, v2 Debug.Print Now For i = 1 To 1000 For j = 1 To 1000 For k = 1 To 1000 v1 = 1 v2 = v1 Next Next Next Debug.Print Now End Sub Sub Test12() Dim i As Long, j As Long, k As Long Dim v1 As Long, v2 As Long Debug.Print Now For i = 1 To 1000 For j = 1 To 1000 For k = 1 To 1000 v1 = 1 v2 = v1 Next Next Next Debug.Print Now End Sub

[moreomoi]

型を宣言する意味のわかりやすい解釈

[rokusan36]

“WorksheetFunction”