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

G

Guest

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

Tom Ogilvy

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"
 
R

Ron Rosenfeld

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA in Citrix. 0
excel spreadsheet functions written in vba 1
Trouble Installing Excel VBA Code Cleaner into Office 365 0
index function in vba 3
Throwing #Value in a UDF written in Excel VBA 4
To SQL Expert: VBA Function that Calls SQL Query 3
Function Pointer in VBA. 4
How to use Excel VBA Help 1

Top