Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
making a portion of reference to a worksheet variable in a formula | Excel Discussion (Misc queries) | |||
Formula to return a value for a portion of a text string in a cell | Excel Discussion (Misc queries) | |||
Return portion of Formula? | Excel Discussion (Misc queries) | |||
return a portion of data entered into a cell | Excel Discussion (Misc queries) | |||
Buttons in lower portion of workbook appear in upper portion | Excel Programming |