Return Portion of Variable

  • Thread starter Thread starter Benjamin
  • Start date Start date
B

Benjamin

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
 
Lookup the Left function (best to use Left$ as it is faster) or Instr in the
VBA help.

RBS
 
Back
Top