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
|