Skip to content

Instantly share code, notes, and snippets.

View isthisthat's full-sized avatar

Stathis isthisthat

View GitHub Profile
@isthisthat
isthisthat / UniqueSelection.bas
Created June 10, 2016 13:54
Excel macro that colors each unique cell text in a selection with a different color
Sub ColorUniqueInSelection()
'
' Colors each unique cell text in selection with a different color
'
Dim tmp As String
Dim arr() As String
' check selection
If Selection.Cells.Count < 2 Then