View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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..
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