• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

go to the next emty cell in column

Belleke

Well-Known Member
Hi,
I have this.
Code:
Set rng = Range("C2")
For i = 0 To LB_00.ListCount - 1
  If LB_00.Selected(i) Then
  rng.Value = LB_00.List(i)
  Set rng = rng.Offset(1)
  End If
Next i
How can I change rng.Offset(1) to Set rng= rng.Offset next empty cell in column C.
Thanks
 
Last edited:
Back
Top