Hi,
Just the basic to hangout with For Loop...
![]()
Sub test() Dim totrow As Long totrow = Range("a1").End(xlDown).Row For i = 2 To totrow For j = 6 To Cells(i, 5) + 6 Cells(i, j) = Cells(i, "A") + j - 6 Next j Next i End Sub
Hi,
Just the basic to hangout with For Loop...
![]()
Sub test() Dim totrow As Long totrow = Range("a1").End(xlDown).Row For i = 2 To totrow For j = 6 To Cells(i, 5) + 6 Cells(i, j) = Cells(i, "A") + j - 6 Next j Next i End Sub
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Thank you very much Debraj Roy!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks