Searching a column for a list of values

Solved/Closed
Charlie - Mar 16, 2011 at 06:34 PM
rizvisa1 Posts 4478 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 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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.
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.