Hi all,
I'm getting the runtime error 13 type mismatch error on the following line of code.
The code it relates to is when a cell is changed in H2 (drop down box).
I get this error when i delete cell values from other cells e.g. when deleting data in range AA30:AA32
Please Login or Register to view this content.
Last edited by Gti182; 12-06-2016 at 07:56 AM.
If you are deleting multiple cells then you need to specifically check the address of the changed cell(s)
If only 1 cell was changed, then no problem, but comparing a range of cells to a single cell will error if more than 1 cell was changed.Please Login or Register to view this content.
Last edited by cytop; 12-06-2016 at 05:32 AM.
Does this work for you?
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thanks Cytop that's very interesting and useful to know, thanks for the code
@ Bakerman2 code is nice and tidy and works great thanks!
You're welcome and thanks for adding rep points.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks