Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

2017-03-02 Thread silvers.r via MS EXCEL AND VBA MACROS
On Thu, 3/2/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 8:34 AM

Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

2017-03-02 Thread karleenbiggs via MS EXCEL AND VBA MACROS
On Thu, 3/2/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 11:58 AM

Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

2017-03-02 Thread silvers.r via MS EXCEL AND VBA MACROS
On Thu, 3/2/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 5:41 PM

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

2017-03-02 Thread margaretatolliver via MS EXCEL AND VBA MACROS
On Thu, 3/2/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: "excel-macros@googlegroups.com" Date:

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

2017-03-02 Thread margaretatolliver via MS EXCEL AND VBA MACROS
On Thu, 3/2/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: "excel-macros@googlegroups.com" Date:

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

2017-03-02 Thread Paul Schreiner
I deleted a row and received the "Type Mismatch" error.If you select "Debug", you'll see that the offending line of code is:   If Target.Value = "OrderStatus" ThenPutting a  "watch" on the Target variable, you'll see that it isn't a single cell, but an array of cells! When you change multiple

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

2017-03-02 Thread silvers.r via MS EXCEL AND VBA MACROS
On Fri, 3/3/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date:

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

2017-03-02 Thread Maatangi M. Karthik
Thanks a lot for your response, Paul. However, my issue got resolved with the help of another forum and was resolved with the help of Combination of "On error resume next " and "Application.EnableEvents=False / true" statements. On Friday, 3 March 2017 01:02:22 UTC+5:30, Paul Schreiner wrote:

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

2017-03-02 Thread Maatangi M. Karthik
Hi there are a few more things I want from the excel. 1. There are some formulae in my excel sheet, I would like to convert them to the backend so that the users cannot change them at any cost 2. There are some fields that affect these formulae in succession, that is, two or three cell values

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

2017-03-02 Thread mintaspriggs via MS EXCEL AND VBA MACROS
On Thu, 3/2/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date:

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

2017-03-02 Thread kenyattafreed via MS EXCEL AND VBA MACROS
On Fri, 3/3/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date:

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

2017-03-02 Thread hopkinsruben865 via MS EXCEL AND VBA MACROS
On Fri, 3/3/17, kenyattafreed via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date:

Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

2017-03-02 Thread silvers.r via MS EXCEL AND VBA MACROS
On Thu, 3/2/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 2:05 PM