[ExcelVBA] Re: specfic character pick

 

I agree that InStr is working. I'm thinking that for each find of the root word, a look at the chars immediately proceeding and following the find, while checking for end of file and "before the file" (don't know what the common terminology for that is), will be required.

Dave G

--- In ExcelVBA@yahoogroups.com, 1z@... wrote:
>
>
> Hmmmm....
>
> My guess is that InStr actually is working but not giving you what you expect.
>
> Can you post what you are passing to your function please?
>
> Have you altered it from the original function code you posted? If so could you post the actual function you are using?
>
> If you want to look for whole words you could try putting spaces around it after removing punctuation.
>
> Have you tried stepping through your function line by line?
>
> Lisa
>
>
>
> Sent: Tue, Aug 21, 2012 3:37 pm
> Subject: Re: [ExcelVBA] Re: specfic character pick
>
>
> whole word lay is itself word and layout not...but Instr is not working "layout"
> word. my requirement is to find "lay" and ignore "layout"
> please help me.
>
> thanks
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (13)

Recent Activity:

• New Members 6

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___