Hi,
I'm trying to Populate a listbox from range (that's easy)
And getting errors if auto-filtering the DataBodyRange by a simple criteria1.![]()
UserForm1.ListBoxResults.List = DB.ListObjects(1).DataBodyRange 'DB is WS
Any idea why?
![]()
UserForm1.ListBoxResults.List = _ DB.ListObjects(1).DataBodyRange.AutoFilter(field:=1, Criteria1:=SortString) 'SortString is just a word
Bookmarks