Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
searching array for text from array
Hey all,
Here is what I'm trying to write a macro to do. I have a column, A, of text. I want to to search/find where this text exists in a separate range. I am having trouble getting the macro to shift the active cell and then search for that term. So, I first want to search range B1:B6 for "dog" and get a report of it's location. Then, I want the macro to shift my active cell to A2 and search B1:B6 for "cat". There will be cases where the search term (ie "cat") doesn't exist. however, all I get is: Columns("A:A").EntireColumn.Select Selection.FindNext(After:=ActiveCell).Activate and this doesn't give me the option to move the active cell (the search criteria). A B 1 dog cat 2 cat horse 3 horse elephant 4 sheep cow 5 cow cat 6 pig dog Or, a simple IF/search formula would work, but I can't get that to work either. For example, I can't get a correct answer for Search(A1, B$1:B$100), even though I know the values exist. thanks, Jordan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching for data in an array. | Excel Discussion (Misc queries) | |||
Searching/Counting an array | Excel Discussion (Misc queries) | |||
Searching for a value in an Array | Excel Worksheet Functions | |||
searching in an array | Excel Discussion (Misc queries) | |||
Searching an Array | Excel Programming |