From: salgud on
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
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
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.
First  |  Prev  | 
Pages: 1 2
Prev: Local cube files
Next: make it text in vlookup