VBA macro examples in Excel
| Introduction | |
| Fill cells with values |
After enabling the Developer tab, you can write and run VBA macros. In this article, you will fill cells with values.
Fill cells with values
After enabling the Developer tab, you can write and run VBA macros.
Fill cells with values
Sub fill_cells()
Dim i As Integer
For i = 1 To 1000
Cells(i, 7).Value = "&#"
Cells(i, 8).Value = i
Cells(i, 9).Value = ";"
Next i
End Sub
Article author: Andrei Olegovich