--------------------------------------------
On Thu, 3/2/17, Paul Schreiner <schreiner_p...@att.net> wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com>
Date: Thursday, March 2, 2017, 9:32 PM
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 cells (even by deleting, or inserting,
or copying), then the Change event is passed an range ARRAY
rather than a single range.
In
your case, you have a choice.You
can add an if() statement like: if
(Target.count > 1) then exit sub
Or,
you can process each cell in the target array
like:
dim
Targ as rangefor
each Targ in Target...
(replace each occurrence of "Target" with
"Targ") ...Next
Targ
Paul-----------------------------------------
“Do
all the good you can,
By all the means you
can,
In all the ways you can,
In all the places you can,
At
all the times you can,
To all the people you
can,
As long as ever you can.” - John
Wesley
-----------------------------------------
On Thursday, March 2,
2017 12:33 PM, Maatangi M. Karthik
<maata...@gmail.com> wrote:
I am absolutely new to
excel VBA.
I have a requirement to create an excel to maintain status
of orders
(there are about 6 / 7 order statuses (2 of which are
OrderStatus(no
status), Enquiry and taken as samples here ) and based on
each status, a
specific set of actions have to be performed. I have
created the excel
in which there are multiple columns & rows, some of the
columns have
data validations either from a reference sheet or entered
as list in
the Data validation part and some have formula
references.
What little coding I could understand, I have done that
based on my
teeny weeny bit of knowledge + the ideas that I got from
checking on
various websites. As a result, I am not sure if I have a
robust code,
although, I have some piece of coding to perform certain
actions based
on values change in certain columns.
Following are the issues that I want help with:
When inserting / deleting row / rows, get error
"Type Mismatch error 13"
The same error appears while certain columns are
extended down to the cells.
Same error while cut copy pasting a row
Although the run time error occurs, the action is
partially completed
Earliest response would be much appreciated.
My sample excel is attached
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
Facebook page of this forum @ https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles,
like Please Help, Urgent, Need Help, Formula Problem, Code
Problem, and Need Advice will not get quick attention or may
not be answered.
2) Don't post a question in the thread of another
member.
3) Don't post questions regarding breaking or bypassing
any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not
allowed.
NOTE : Don't ever post confidential data in a workbook.
Forum owners and members are not responsible for any
loss.
---
You received this message because you are subscribed to the
Google Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails
from it, send an email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
Facebook page of this forum @ https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles,
like Please Help, Urgent, Need Help, Formula Problem, Code
Problem, and Need Advice will not get quick attention or may
not be answered.
2) Don't post a question in the thread of another
member.
3) Don't post questions regarding breaking or bypassing
any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not
allowed.
NOTE : Don't ever post confidential data in a workbook.
Forum owners and members are not responsible for any
loss.
---
You received this message because you are subscribed to the
Google Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails
from it, send an email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
Desavarsirea unitatii nationale a statului roman223
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
