case is string contains string?
in [Programming]
|
Prev: Local cube files
Next: make it text in vlookup
From: salgud on 23 Mar 2010 12:14 On Tue, 23 Mar 2010 07:38:15 -0600, salgud wrote: > On Mon, 22 Mar 2010 16:29:40 -0600, salgud wrote: > >> I have played with it for an hour, but can't figure out how to make a case >> statement that would be something like: >> >> Case is = (string1 contains string2) >> >> Is there a way to do this? >> Thanks! > > Thanks to all! Gave both methods a try, but neither works! I'm setting a case for worksheets that have "Monthly" in their sheetname (sWsName) I put in: Case sWsName like "Monthly" and Case "Monthly" Like sWsName and Case instr(1,lcase(sWsName),"monthly") and Case InStr(1, sWsName, "Monthly") Am I missing something?
From: Bob Phillips on 23 Mar 2010 15:19 Not much point us answering if you don't read it Case sWsName like "*Monthly*" -- HTH Bob "salgud" <spamboy6547(a)comcast.net> wrote in message news:13drqf4b0ylna.1uvx7myxyhma4.dlg(a)40tude.net... > On Tue, 23 Mar 2010 07:38:15 -0600, salgud wrote: > >> On Mon, 22 Mar 2010 16:29:40 -0600, salgud wrote: >> >>> I have played with it for an hour, but can't figure out how to make a >>> case >>> statement that would be something like: >>> >>> Case is = (string1 contains string2) >>> >>> Is there a way to do this? >>> Thanks! >> >> Thanks to all! > > Gave both methods a try, but neither works! I'm setting a case for > worksheets that have "Monthly" in their sheetname (sWsName) > > I put in: > > Case sWsName like "Monthly" > > and > > Case "Monthly" Like sWsName > > and > > Case instr(1,lcase(sWsName),"monthly") > > and > > Case InStr(1, sWsName, "Monthly") > > Am I missing something?
From: salgud on 23 Mar 2010 15:51
On Tue, 23 Mar 2010 19:19:10 -0000, Bob Phillips wrote: > Not much point us answering if you don't read it > > Case sWsName like "*Monthly*" Thanks for your help. |