Previous Topic Next Topic

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

Answer 1 / 2
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.
1
Answer 2 / 2
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

Similar discussions

Facebook Messenger - Suggested Friends
jadess_0462 -
Akajackal -

2 responses
Anyone's dm order all weird ?
Tillyleon111 -
toogleeful -

2 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
What is the first name of your favorite uncle?
Yusieda88 -
Ambucias -

1 response