VS 2005 Tools for Office Find error

Hi

I am getting an error on xlNext in the following code
rFound = oWb.Range(Detail).Find(oWhat, rngFoundInst, oLookin, oLookat, oSearchOrder, xlNext, False, False)
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Wayne Taylor (webtubbs)Connect With a Mentor Commented:
Try either of these....

rFound = oWb.Range(Detail).Find(oWhat, rngFoundInst, oLookin, oLookat, oSearchOrder, Excel.XlSearchDirection.xlNext, False, False)

rFound = oWb.Range(Detail).Find(oWhat, rngFoundInst, oLookin, oLookat, oSearchOrder, 1, False, False)
0
 
Wayne Taylor (webtubbs)Commented:
What's the error? I can see a number of things that could be the problem, but then again, they may not.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
xlNext not declared
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.