Dear Members,
A new tip of excel has been published on the blog . The title of
the tip is "User-level prevention is a magic cure".
Please visit the below link for this tip.
http://exceldailytip.blogspot.com/2009/01/tip-46-user-level-prevention-is-magic.html
To see the archive of these Daily Exc
I have a macro that loops through a range of cells. It takes the text
in the cell, determines the appropriate validation group (a range of
cells on another spreadsheet) and compares it to that range. If it
finds the value, it changes the color to blue, if it doesn't find the
value in the list, t
