I am using an userform with a listbox and I want to export the filtered listbox contents into an excel file.
myarray = Sheet61.ListObjects("Data").DataBodyRange.Value
With ListBox1
.List = myarray
.ColumnCount = 25
.ColumnHeads = False
End With
This code loads the DataBodyRange.Value into...