Thread: how do i use the excel function search in excel vba?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default how do i use the excel function search in excel vba?
You should use the vba function Instr instead of Search.

Instead of Value you should use the vba function Val

better to use VBA functions in VBA if they do the job.

--
Regards,
Tom Ogilvy



"Excel programming questions"
om wrote in message
...
I want to use the excel functions value and search in excel vba code.
How do I do this


Reply With QuoteReply With Quote