Greetings All
The following code will populate my ListBox from only the active worksheet even though I have stipulated to pull the data from a specific worksheet
As always,
Thank You for any assistance
RT 91
The following code will populate my ListBox from only the active worksheet even though I have stipulated to pull the data from a specific worksheet
Code:
Dim Ws1 As Worksheet
Set Ws1 = ThisWorkbook.Sheets("Addrs & OBs")
LrA = Ws1.Cells(Rows.Count, 1).End(xlUp).Row
ListBox1.RowSource = ("A2:A" & LrA)
End Sub
As always,
Thank You for any assistance
RT 91