Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

using FIND method

Status
Not open for further replies.
Luis939

Luis939

MIS
Feb 28, 2003
453
US
hope im not gettin too annoying with my questions, but is there any way of using the find method for more than one string, lets say i know that in column A ill have the words interstate or intrastate, how do i make it so that it can search for the first instance of any one of these words, which ever comes up first, thanks!!
 
Sort by date Sort by votes
Not sure that you can submit two different values in one Find, but it would be pretty easy to do a find for each value and then see which found cell is closer to the top.

VBAjedi [swords]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Using Err.Raise question
Replies
2
Views
902
mintjulep
M
aldi07
  • Locked
  • Question
update a front-end databases with a new release using vba
Replies
2
Views
281
aldi07
aldi07
thanhthanh12
  • Locked
  • Question
Find different of word two documents in vba
Replies
3
Views
226
thanhthanh12
thanhthanh12
feipezi
  • Locked
  • Question
How to find a string from multiple Word files, which are listed on an Excel spreadsheet? 3
Replies
17
Views
669
Andrzejek
Andrzejek
Katto
  • Locked
  • Question
Translate word document using VBA
Replies
5
Views
510
macropod
macropod

Part and Inventory Search

Sponsor

Back
Top