[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 170
  • 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)AstronautCommented:
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)AstronautCommented:
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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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