VBA: Highlight Duplicates in a Range
(AutomateExcel) The following subroutine will highlight all the duplicates values in range in yellow. It does not matter whether the values are text or numbers. It uses Excel's COUNTIF function to count up the duplicates and then sets the colour to yellow:
Sub Highl
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 3651 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 3651]
updated 3651 (Automate Excel), inserted 0, updated 0, at 2012-05-31 00:58:18
