View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Benjamin Benjamin is offline
external usenet poster
 
Posts: 102
Default Return Portion of Variable

I have a variable Being the Cell's contents (Which are the file path name)

i.e. I'm using the file path, and it's important that I search the variable
Documents\Priority
Documents\Concerns
Documents\Attachments

I want to do an if statement for all paths that have
Documents in the variable I want to do "Action B" for example and everything
else:
"Action A"

How to I search for just "Documents" in the Variable