Thread: some functions doesnt work in macro?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_2_] Patrick Molloy[_2_] is offline
external usenet poster
  
Posts: 1,298
Default some functions doesnt work in macro?
many functions have VBA equivalents. However, precede sheet functions with

WorksheetFunction.

note that some functions, eg VLookup will raise an error if the value being
looked for doesn't exist in the table being searched ... so you need to trap
these properly.

HELP is quite good with examples for the FIND method




"ExcelPower" wrote:


hi
can any one plz tell me that why functions like Find, Search,
Concatenate dosent work in macro? do i need to add any reference?
plz tell me

thks in advance


--
ExcelPower
------------------------------------------------------------------------
ExcelPower's Profile: http://www.excelforum.com/member.php...o&userid=30964
View this thread: http://www.excelforum.com/showthread...hreadid=514121


Reply With QuoteReply With Quote