Member Avatar for James778

Hi Everyone,
I have sheet with rows filled with text, and I copy each row and paste it in another sheet,(paste special transpose). I created a macor for this step. but how to add the loop code so it keep doing the same steps till empty.

Thanks

  • 2 Contributors
  • 1 Reply
  • 41 Views
  • 5 Minutes Discussion Span
  • Latest Post Latest Post by ddanbe
Member Avatar for ddanbe

Try this macro on a new sheet and see what happens:

Dim i As Integer

For i = 1 To 10
    Cells(i, 1).Value = i * 5
Next i
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.