How to use Excel Functions in VBA?
 

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..:confused:
So please tell me how to use it?

Thanks in advance
john bes

--
johnbes
-----------------------------------------------------------------------
johnbest's Profile: http://www.excelforum.com/member.php...fo&userid=2969
View this thread: http://www.excelforum.com/showthread.php?threadid=49604

How to use Excel Functions in VBA?
 

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..:confused:
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

How to use Excel Functions in VBA?
 

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..:confused:
So please tell me how to use it?

Thanks in advance
john best



Application.WorksheetFunction.Search