LinkBack URL
About LinkBacks
Hi all,
I need macro to check the range L3:L2500 for colorindex = 3 and if its found show the massege box or if not then go next.
Hi all,
I need macro to check the range L3:L2500 for colorindex = 3 and if its found show the massege box or if not then go next.
Try this:
Please Login or Register to view this content.
Never use Merged Cells in Excel
Stop with
"out of range"Please Login or Register to view this content.
Change sheet name Sheet3 to your real sheet name.
I did it zbor. That's the full code I want to use it:
Please Login or Register to view this content.
I think I now the problem. If I fill the color manual then works ok, but when the color is from Conditional Formating then it's not.
Yes. Works if cell is colored in red.
For Conditional Formatting why don't you use CF criteria to check your data?
That's what I do. CF is checking the match between column K&L and if its different then colour in red. And the macro above is printing me report. But I'm not suppose to do that when red colour is in L. That why I wanted to add the msgbox before my code. Is there anything I can do about it?
Upload example workbook.
Make sure to remove all private informations but leave only what's important to understend problem.
Here you go zbor.
Last edited by Rufles; 03-14-2014 at 08:56 AM.
Your sheet is protected
Sorry protection removed ;-)
PerhapsPlease Login or Register to view this content.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Solus Rankin this is what I was looking for. Didn't think that way - excellent.
Thank you all for help.
Problem SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks