try advance filter
for criteria copy thelist of names in textbox into an excel range with the
column headings


Lynn wrote in message
...
Hi,
I have an excel spreadsheet which consists of columns names, phone nos.,
address, etc.
How can i automate excel to highlight those rows that consists of the list
of names in a text file?
thanks