Hello
I have nearly the perfect macro for my job, but I need one little change. The thing I is that my macro should color the row within the search conditions is and the two rows below. At this moment it only colors the row with the search result.
Heres my macro:
Looking forward to get some help
Please Login or Register to view this content.
Anders
Denmark
Last edited by Anders.Hoejlund; 07-21-2010 at 07:37 AM.
Please Login or Register to view this content.
The smallest change I can think of would be to just add this:
Please Login or Register to view this content.
SNB, yours is intriguing but not working for me. I get error messages when I insert that into a module.
Last edited by JBeaucaire; 07-19-2010 at 09:46 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
@JBeaucaire
See the attachment.
Very intriguing, something new to pull apart.
@JBeaucaire
To provide you with another example, using the same techniques for quite another purpose, look here.
Yeah, I'd seen that before. I have a rule against variables that give no indication what they do, code is hard enough to read without intentionally creating variables that make it significantly harder to decipher, I think we've talked about this briefly in the past.
I know that means the code will be longer, but longer and legible wins for me from a teaching standpoint.
The technique is pretty advanced as it is...
Thank you all very much, I inserted + 2 and deleted the part of the code wich gave default no color, this kindly deleted the coloring of the two rows below, just after they were colored. It works now.
Have a nice day
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks