View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rk Rk is offline
external usenet poster
 
Posts: 18
Default handling calculated excel cell error messages

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.