I'm trying to add items to the second column of a listbox using vlookup but i keep getting a run-time error 380 "cound not set the List property. Invalid property value.
I can't figure out what is going on. the column count is set to 2 on the listbox.
'Adds Items to column 2 of listbox
With Me.SalesReportLB
For j = 0 To SalesReportLB.ListCount - 1
x = Application.VLookup(SalesReportLB.List(j), SheetNum.Range(CatCol & "1", SheetNum.Range("C" & Rows.Count).End(xlUp)), 3, False)
.List(j, 1) = x
Next j
End With
it fails on this line
any help would be great
Bookmarks