On Sun, 1/29/17, storeythomas725 via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE
To: excel-macros@googlegroups.com
Date: Sunday, January 29, 2017, 10
On Sun, 1/29/17, georgemartin812 via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE
To: excel-macros@googlegroups.com
Date: Sunday, January 29, 2017, 7
On Sun, 1/29/17, silvers.r via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE
To: excel-macros@googlegroups.com
Date: Sunday, January 29, 2017, 5
On Sat, 1/28/17, keisha.fry via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE
To: excel-macros@googlegroups.com
Date: Saturday, January 28, 2017, 12
On Sat, 1/28/17, kenyattafreed via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE
To: excel-macros@googlegroups.com
Date: Saturday, January 28, 2017, 10
On Sat, 1/28/17, mintaspriggs via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE
To: excel-macros@googlegroups.com
Date: Saturday, January 28, 2017, 9
On Sat, 1/28/17, mintaspriggs via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE
To: excel-macros@googlegroups.com
Date: Saturday, January 28, 2017, 5
On Fri, 1/27/17, Greg Della-Croce <greg_della-cr...@sil.org> wrote:
Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE
To: excel-macros@googlegroups.com
Date: Friday, January 27, 2017, 4:00 PM
You all caught the
p
ps.com> wrote:
>
> Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE
> To: excel-macros@googlegroups.com
> Date: Friday, January 27, 2017, 9:50 AM
>
>
>
> On Thu, 1/26/17, libertystringer via MS EXCEL
On Fri, 1/27/17, georgemartin812 via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE
To: excel-macros@googlegroups.com
Date: Friday, January 27, 2017, 9
On Thu, 1/26/17, libertystringer via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE
To: excel-macros@googlegroups.com
Date: Thursday, January 26, 2017,
On Thu, 1/26/17, julienneschindler via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE
To: excel-macros@googlegroups.com
Date: Thursday, January 26, 2017
On Thu, 1/26/17, Vicky <jorwalvi...@gmail.com> wrote:
Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE
To: excel-macros@googlegroups.com
Date: Thursday, January 26, 2017, 6:53 PM
Hi Greg,
The given code only work
Hi Greg,
The given code only works when you are comparing the contents of the entire
cell from one in the range. It won't work if your chkFor cell is matching
partially with one of the cells from range.
Regards,
Vicky
On 26-Jan-2017 9:47 PM, "Greg Della-Croce" wrote:
Vicky, thanks for the idea. I will see how it works for me. I appreciate
the time/effort you put in to help me!
Greg
Greg Della-Croce
Skype: gdellacroce55
Cell: 407-408-2572
greg_della-cr...@sil.org
"If you assume you know the answer, you will miss having a breakthrough.
It’s okay to do what
Hi Greg,
I have found a solution. Hope this helps!
Function Contains(ChkFor As String, ChkRng As Range)
For Each cell In ChkRng
If cell.Value = ChkFor Then
Contains = "Found"
Exit For
Else
Contains = "Not Found"
End If
Next cell
End Function
The above code
16 matches
Mail list logo