/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 vote161 views1 answer
Vba clear collection
VBA
0 vote143 views1 answer
Vba code for cutoff time
VBA
0 vote139 views1 answer
Excel vba populate array with cell values
VBA
0 vote164 views1 answer
Vba count all row
VBA
5 votes171 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote154 views4 answers
How to continue formula in below line in vba code
VBA
0 vote159 views1 answer
Vba copy file
VBA
1 vote160 views1 answer
Vba format string as cash
VBA
0 vote145 views1 answer
Vbnet check if sting contians symbols
VBA
0 vote150 views1 answer
Dynamic array vba
VBA