handling calculated excel cell error messages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I try finding a text string within another test string (for exmaple
using "find" or "Search") it returns a value when the text string is found.
However, when the text string is not found it returns an Error ("#Value!").
I'd like to autmatically calulate the cell as "Y" if the text string was
found or "N" if it was not found.
 
Use instr inplace of find or before search

if instr(string1,",") > 0 then
'put find or search here
end if
 

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

Need simple formula to find one string in another 4
*.Find() 3
Excel Functions 6
Search and Replace Entire Cell Content 3
Nested String Search and Return Value. 3
VBA Multiple Line handling with Split() 1
Conditional Format based on sub-string 3
Getting a message box program to run (Page 43 of 'BeginningProgramming with VBA' by Duane Birnham) 11

Back
Top