Macro Excel : Looping Within Column and Row

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

About riahantoro
rhantoro.net

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: