Searching a column for a list of values

Solved/Closed
Charlie - Mar 16, 2011 at 06:34 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Mar 17, 2011 at 08:38 AM
Hello,
I am using a macro to search for a list of values that i want to be written into the macro (Permanently). currently i am looping after each search to the top of the column. How do i define "i" as a list of values so it searches for each value for every row before it goes to the next row?
Charlie


2 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Mar 17, 2011 at 08:38 AM
you can have an input box where you can enter the values to be searched and then in a do loop for each item entered in the box you could search for thing.
1
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 17, 2011 at 12:27 AM
try to record a macro in excel by record macro button it will help you.
0