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?
6 Replies
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 SubMaybe with simple VBA code.
- That's Great, Thanks
- Select row,
F2
write word
control + intro- Thank You
- Thank you so much
