Search and Find Missing In Action
It would help if you provided some source code so we could see what you are
doing.
I use "Find" quite a bit in my code.
Are you using it as a member of a range object? Are you setting a range
object to the return value?
The following code works for me. It finds a cell in column 2 that contains
the text "Six Sigma.":
Sub TestFind()
Dim r As Excel.Range
Set r = Worksheets("Sheet1").Columns(2).Find("Six Sigma", , xlValues,
xlPart)
End Sub
"LarryP" wrote in message
...
I'm trying to write VBA using either Search or Find to determine if string
A
exists in string B, and the debugger insists it doesn't recognize either,
although Help alleges they are available to VBA. Anyone have an idea why
the
error? No missing references.... (Excel 2003 SP3/Windows XP)
|