Hi Arvind,
You can achive this using formula also.
PFA excel.
Regards,
Swapnil.
On Thu, Feb 13, 2014 at 1:17 PM, pankaj sangotra wrote:
> Please try this hope this will help..
>
> Sub output()
> Dim i As Integer, k As Integer, j As Integer
> k = 1
> For i = 1 To 5
> For j = 97 To 100
>
Please try this hope this will help..
Sub output()
Dim i As Integer, k As Integer, j As Integer
k = 1
For i = 1 To 5
For j = 97 To 100
Cells(k, 1).Value = i & Chr(j)
k = k + 1
Next
Next
End Sub
On Thu, Feb 13, 2014 at 12:52 PM, arvind sharma Rajendra <
arveensharm...@gmai