Hello, I have some code here that I am using to find matches in Column D and then remove colored cell once the match is found. I am in putting the data line by line from a Barcode scanner and only want to run the macro if the date in Column A is today. Here is the code I am using.
Please Login or Register to view this content.
Last edited by 6StringJazzer; 02-07-2014 at 05:20 PM. Reason: fixed code formatting
my guess would be something like putting an IF statement after the start of your FOR loop
this is untested....Please Login or Register to view this content.
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Nu2Java, the leading stars in your code impair readability and make it impossible to copy and paste this code to test or modify it. I suggest you edit your text to replace each star with a space. The CODE tags will preserve the spacing; it's not necessary to insert leading characters to force the desired spacing. Thanks.
Sorry for the code with leading stars, I pasted my code from my phone and somehow it added those stars.
Thanks judgeh59... I tried that but it seems to just exit the for loop no matter what the date is.
I fixed the code formatting for you.
Thanks for fixing the code format. Does anyone have any ideas on what I am trying to accomplish here? Thanks in advance.... Cuz I'm stuck.
I need to update my original request. In my sheet, there can be hundreds of rows, and only maybe fifty rows that I want to run the macro for, which I want to run each day. So I want the macro to exclude all rows that are NOT the current day.
I don't understand how your original request and your post immediately above are different. Anyway, insert the red code to process only those cells where the date in column A is not today.
However, I am confused about what you are trying to do. Your first If statement uses Countif so that the cell will be processed only if it is a unique value within that range. Then you use Find to find other values, which it won't since the value is unique. Other than the day issue, does your code do what you want it to do?
Please Login or Register to view this content.
Thanks for the help on this. Yes, my code does work how I need it to other than the date. How it works now is, in Column D I am entering part numbers and coloring the cell when NO duplicate is found. Once the duplicate is found, the cell color goes back to white. What I need is for the code to ignore the rows in Column D that are not today in Column A. So if I had a colored cell yesterday because of no duplicate, I want it to stay that way. I hope that makes sense.
Hi Nu2Java,
I am not sure I totally understand, but try the code below which should be working with Excel 2003. Otherwise if you could upload your workbook without any sensitive data and we could go from there.
Cheers, berlanPlease Login or Register to view this content.
Hi Berlan,
Thanks for the reply and your help. I tried your code but get an error on "If Evaluate" Line. I will try to explain the best I can along with attached file. I will basically start this excel file lets say Today, and when I run the macro, all cells in Column D will turn a different color if no match is found (which is what I want). But what I need to add is, when I run this code tomorrow, I want the cells in Column D from today to remain colored as there was no match found yesterday. So like in my attached file, "PART_D" is the only one on 1/29/2014 that had a match and the cells are white. PART_A, PART_B, PART_C remain colored as they are on different dates, along with PART_D that is now on a new date. I hope I have explained it correctly. Thanks for your help.
Hi again, please try the attached
Just a question when it comes to coloring your cells. For instance, PART_A (which has no duplicates for the latest date - in A1) will match the color of PART_A at a different date, is that what you want as well?
Cheers, berlanPlease Login or Register to view this content.
Last edited by berlan; 02-08-2014 at 07:39 PM.
Hi Berlan,
This is looking like EXACTLY what I need. If the colors can match for the different dates, that would be a GREAT addition, I had not thought of that. Thanks very much for your time and help.
You're welcome, glad I could help
If you're satisfied by any members response to your issue in this thread, please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks