Anyone have an idea how I may convert this piece of code so that the results found (entire row) of a search may be presented in a "list box" instead of just pasting to another row?
I've attempted a few ideas with not quite the results I had expected for starters, only the first cell is returned...
Code:
Found.EntireRow.Copy _
Destination:=Worksheets("Results").Range("A2").End(xlUp).Offset(1, 0)
Sheets("Results").Select
I've attempted a few ideas with not quite the results I had expected for starters, only the first cell is returned...