G Guest Feb 9, 2005 #1 I want to use the excel functions value and search in excel vba code. How do I do this
T Tom Ogilvy Feb 9, 2005 #2 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"
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 Feb 9, 2005 #4 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
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
