Macro Excel : Looping Within Column and Row
January 2, 2012 Leave a comment
Macro Excel :
Menulis sebuah string perulangan diantara kolom (misal Kolom C sampai G) dan baris (misal Baris 3 sampai 6) dengan menggunakan Index,
berikut Macro nya ::
Sub LoopingWithinRowColumn()
Dim i As Integer
Dim j As Integer
For i = 3 To 6
For j = 3 To 7
Cells(i, j).Value = “hallo”
Next j
Next i
End Sub
Advertisements
Recent Comments