Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-29 Thread julienneschindler via MS EXCEL AND VBA MACROS
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

Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-29 Thread storeythomas725 via MS EXCEL AND VBA MACROS
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

Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-28 Thread georgemartin812 via MS EXCEL AND VBA MACROS
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

Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-28 Thread silvers.r via MS EXCEL AND VBA MACROS
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

Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-28 Thread keisha.fry via MS EXCEL AND VBA MACROS
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

Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-28 Thread kenyattafreed via MS EXCEL AND VBA MACROS
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

Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-27 Thread mintaspriggs via MS EXCEL AND VBA MACROS
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

Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-27 Thread mintaspriggs via MS EXCEL AND VBA MACROS
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

Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-27 Thread Greg Della-Croce
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

Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-27 Thread martinez.david533 via MS EXCEL AND VBA MACROS
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

Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-26 Thread georgemartin812 via MS EXCEL AND VBA MACROS
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,

Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-26 Thread libertystringer via MS EXCEL AND VBA MACROS
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

Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-26 Thread julienneschindler via MS EXCEL AND VBA MACROS
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

Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-26 Thread Vicky
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:

Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-26 Thread Greg Della-Croce
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

$$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-26 Thread Vicky
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