Forum Discussion
Solved
Want to add a word in all column easily
I want to add a word in my all column there are about 10M column, is there any option in Microsoft Excel? Like 1word 2word 3word 4word . . . . etc. How can i do that?
Sub word()
Dim i As Double
Dim j As Double
For i = 1 To 100
For j = 1 To 50
Cells(i, j).Value = i & "Word"
Next j
Next i
End Sub
Maybe with simple VBA code.
That's Great, Thanks