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

Return Portion of Variable
 

Lookup the Left function (best to use Left$ as it is faster) or Instr in the
VBA help.

RBS


"Benjamin" wrote in message
...
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