/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

3 votes125 views1 answer
Excel vba make long from two shorts
VBA
0 vote178 views1 answer
Vba excel do not recalculate before save
VBA
0 vote131 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote136 views1 answer
Add text to combobox drop down vb
VBA
0 vote141 views1 answer
Default host vbox address
VBA
0 vote146 views1 answer
For each item in folder outlook vba
VBA
3 votes143 views1 answer
Vba double quote
VBA
0 vote150 views1 answer
Vba search string position
VBA
0 vote141 views1 answer
Open file dialog in vb.net
VBA
1 vote126 views1 answer
If inputbox cancel vba
VBA