I need the range to go from A150 to A7 since its current state it missed rows if there are multiple rows that need to be deleted.
With ListBox1
For i = 0 To .ListCount - 1
If .Selected(i) Then
Set r1 = Range("A7:A150")...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.