[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 168
  • Last Modified:

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)
0
Murray Brown
Asked:
Murray Brown
  • 2
1 Solution
 
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
 
Wayne Taylor (webtubbs)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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now