Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am evaluating a relatively large data set by using (among other things)
InStr against a search string variable. Dim strSearchList As String strSearchList = "ROL, REG, OT-, PN2" On each pass through a sub-process where this is used other qualifying factors are evaluated. Once all qualifying factors are met, the "found" item in the string is "used", but must be ignored on subsequent passes through. So, if I process for the "REG" element, what I need to do is re-state strSearchList as "ROL, OT-, PN2" -- that is, with the "REG" removed. So how do I do that? -- Dave Temping with Staffmark in Rock Hill, SC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
why do i "sometimes" need to "edit chart object" before "source da | Charts and Charting in Excel | |||
Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) | |||
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming |