I was wondering if someone could help, the below code works fine in 2007 onwards, but the line Selection.FormatConditions.AddUniqueValues is bugging out. I know its because im using a format that wasn't available in 2003 but what would be the comparison.
Sorry now amended
Please Login or Register to view this content.
Last edited by bopsgtir; 04-11-2013 at 04:49 AM.
please add code tags to your post then we can start fixing it :-)
Josie
if at first you don't succeed try doing it the way your wife told you to
Anyone, basically just trying to remove duplicates without using the new built in feature.
Hi, bopsgtir,
most of the comands (AddUniqueValues, SetFirstPriority, DupeUnique, xlThemeColorLight1, and TintAndShade AFAIK) where introduced with Excel2007. In Excel2003 you would need to use a formula which won´t let you enter the same item again. But you could get there by using the Worksheet_Change-Event as well.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks