how do i use the excel function search in excel vba?
 

I want to use the excel functions value and search in excel vba code.
How do I do this

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

how do i use the excel function search in excel vba?
 

Thank you very much

"Excel programming questions" wrote:

I want to use the excel functions value and search in excel vba code.
How do I do this

how do i use the excel function search in excel vba?
 

On Tue, 8 Feb 2005 17:49:02 -0800, Excel programming questions
om wrote:

I want to use the excel functions value and search in excel vba code.
How do I do this

You can use SEARCH

Application.WorksheetFunction.Search

but I think VALUE you will have to use a VBA equivalent. What exactly do you
want to do?


--ron