vba and How do I add a second value that is also in the doc?!

[magleremm]

Hello Everyone,

I'm pretty new to macros and I have this code that works wonderfully except for it will not let me add a second value to search with. Below is the particular section of the code I’m having issues with -

Please Login or Register  to view this content.

I want it to have 2 values – tiger and tigertwo

When I put - Value:=tiger And tigertwo it says Run-time Error “13”: type mismatch.

When I put - Value:=tiger
,_SecondValue:=tigertwo it finds everything with both types of variables instead of docs with both variables in it.

*** it is looking thru text files ***

For example Below each number represents a report being searched thru. The words in the report on the respective line
1. fish
2. chips
3. fish horse chips
4. horse
5. fish chips
6. chips fish horse
7. horse chips fish
8. apples chip
9. horse fish
I would like the macro to only return reports 3, 5, 6,7

My entire code is below –

Please Login or Register  to view this content.

Please help!

Thank you very, very much in advance!!!

[Oredigger90]

If it were me, I would simply concatenate your tiger and tigertwo columns into one column in your base file. Just populate that concatenate formula, I believe it is =A1'& &'B1
and then you will only have one search parameter to go through and find it. Also, put code wraps around your code, they'll freak out on here if you don't do that on your posts, especially if you started the thread.

[magleremm]

Thank you! I totally forgot to put code wraps!

I would totally follow ur advice but it is searching thru text files so there are no columns to do the concatenate

[Oredigger90]

hmmm... I'm not quite sure then, I'll try to do some research and get back to you