How to use Excel Functions in VBA?

[johnbest]

Hi there

While using Excel Search Function in VBA programming, I got
"Sub or Function not defined!!" Error...

But need to use the Search funtion..
So please tell me how to use it?

Thanks in advance
john best

[Kris]

johnbest wrote:
> Hi there
>
> While using *Excel Search Function* in VBA programming, I got
> "*Sub or Function not defined!!*" Error...
>
> But need to use the Search funtion..
> So please tell me how to use it?
>
> Thanks in advance
> john best
>
>

Application.WorksheetFunction.Search

[Dave Peterson]

do you mean the worksheet function =search()?

If you do, then you may want to read about VBA's InStr() function. It's
built-in and works pretty much the same.

johnbest wrote:
>
> Hi there
>
> While using *Excel Search Function* in VBA programming, I got
> "*Sub or Function not defined!!*" Error...
>
> But need to use the Search funtion..
> So please tell me how to use it?
>
> Thanks in advance
> john best
>
> --
> johnbest
> ------------------------------------------------------------------------
> johnbest's Profile: http://www.excelforum.com/member.php...o&userid=29694
> View this thread: http://www.excelforum.com/showthread...hreadid=496043

--

Dave Peterson