Thread: How can I use wildcards in IF statements and Macros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AlanF AlanF is offline
external usenet poster
  
Posts: 1
Default How can I use wildcards in IF statements and Macros
I want to include in a Macro, something to take a particular action if the
active cell contains text beginning with X. I thought something based on an
IF statement, that included a wildcard, might work, e.g. IF(A1="X*,1,0). This
does not work though.
Reply With QuoteReply With Quote