Jan 11 2022 10:42 AM
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?
Jan 11 2022 10:55 AM
SolutionJan 11 2022 11:03 AM
Jan 11 2022 11:07 AM
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.
Jan 11 2022 10:55 AM
Solution