sharky12345
Well-known Member
- Joined
- Aug 5, 2010
- Messages
- 3,404
- Office Version
- 2016
- Platform
- Windows
How can I either change this or amend it so that it also pastes to Sheets("Stock") from D4 down?
Code:
If ListBox2.Selected(i) = True Then Worksheets("Issued").Range("B65536").End(xlUp).Offset(1, 0).Value = ListBox2.List(i)