/VBA/Excel vba highlight cells using the hex color value within the cells

Excel vba highlight cells using the hex color value within the cells

'VBA function to color cells in selected range based on the hex
'color number entered in each cell. For example, #FF69B4

Sub ColorCellsByHex()
    Dim r
    If TypeName(Selection) <> "Range" Then Exit Sub
    For Each r In Selection
        r.Interior.Color = Abs(("&H" & Mid(r, 6, 2) & Mid(r, 4, 2) & Mid(r, 2, 2)))
    Next
End Sub

Source: academy.excelhero.com

Similar codes

0 vote184 views1 answer
Vba round to 2 decimals
VBA
0 vote195 views1 answer
Vba test optional argument
VBA
0 vote145 views1 answer
Vbide vbproject reference
VBA
3 votes187 views1 answer
Extract the nth word from a text string
VBA
-1 vote198 views1 answer
How save excel through visual basic
VBA
0 vote199 views1 answer
Move bindingnavigator vb
VBA
0 vote186 views1 answer
Vbnet round to nearnest thousand
VBA
1 vote193 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote167 views1 answer
Excel vba arrondir
VBA
0 vote190 views1 answer
Do while not vb.net
VBA