Hi, I want K to clear every time there is an update whether it is changing value or delete value (blank). I tested single code in separate sheet and it work fine, but when I put all my codes together. COL K only clear when I make change to W:AP but when I delete value from W:AP, COL K doesn't clear.
Thank you!
Please Login or Register to view this content.
This line exits the sub if the target is more than one cell or is empty.Please Login or Register to view this content.
You later try to loop through all the target cells in column W:AP that you cleared. That part of the code never runs if you deleted more than one cell.
Try putting the code to Clear Verification before Prevent duplicate name.
Last edited by AlphaFrog; 03-29-2017 at 09:27 PM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi I tried to swap the code then 'Prevent Duplicate Name code show error at line
Thank you for your help!
Please Login or Register to view this content.
Try this (not tested).
Please Login or Register to view this content.
It work perfectly! Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks