0

I have been looking online to find documentation for the function in QTP and have not been able to find anything that explains it well. Could someone please help.

The line of code looks like this:

obj_Sheet.UsedRange.Find(Variable_Name,,-4163,1)

Can someone explain to me what the Find() function does, and what parameters it expects.

Thanks you

Zzz
  • 2,927
  • 5
  • 36
  • 58

1 Answers1

2

The Find function for Excel VBA is described at MSDN. The easiest way to view the possible values of the properties in Excel VBA editor itself: In Excel: Press ALT+F11 for the VBA editor, then select F2 to open the object browser. In the object browser you can lookup the values for xlPart, xlWhole, xlValues etc.

The parameters in your script mean:
-4163 : xlValues (search in values, not in formula's)
1 : xlWhole (the value in the cell must be matching the lookup value completely, not partly)

AutomatedChaos
  • 7,267
  • 2
  • 27
  • 47