Have to repeat list
Closed
kashif.aali
Posts
1
Registration date
Tuesday May 16, 2017
Status
Member
Last seen
May 16, 2017
-
May 16, 2017 at 02:17 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - May 16, 2017 at 11:12 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - May 16, 2017 at 11:12 AM
Related:
- Have to repeat list
- Contact number list - Guide
- How to change your best friends list on snapchat to 3 - Guide
- Dos command list - Guide
- Network cmd commands list pdf - Guide
- Samsung reset codes list - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
547
May 16, 2017 at 11:12 AM
May 16, 2017 at 11:12 AM
Hi Kashif.aali,
Give the following code a try:
Best regards,
Trowa
Give the following code a try:
Sub RunMe() Dim x, y, z As Integer x = 1 y = 1 z = 1 Do Cells(x, "C").Value = Cells(y, "A") & " " & Cells(z, "B") x = x + 1 z = z + 1 If z > 3 Then y = y + 1 z = 1 End If Loop Until IsEmpty(Cells(y, "A")) End Sub
Best regards,
Trowa