Have to repeat list
Closed
kashif.aali
TrowaD
- Posts
- 1
- Registration date
- Tuesday May 16, 2017
- Status
- Member
- Last seen
- May 16, 2017
TrowaD
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Related:
- Have to repeat list
- Excel repeat list x times - Guide
- How to make your best friends list on snapchat smaller - Guide
- Little alchemy list - Guide
- Samsung guru block list - Guide
- List installation steps of jsdk - How-To - Webmaster
1 reply
TrowaD
May 16, 2017 at 11:12 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
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