/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 vote143 views1 answer
Remove first character from string vb
VBA
0 vote139 views1 answer
Vba get text file content
VBA
0 vote146 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote137 views1 answer
Vba collection key list
VBA
0 vote137 views1 answer
Excel vba address not absolute
VBA
18 votes279 views3 answers
Excel-vba make integer
VBA
1 vote136 views1 answer
VBA Loop through recordset
VBA
-1 vote140 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote139 views1 answer
Loop through lines in text file vb net
VBA
0 vote157 views1 answer
For each item in folder outlook vba
VBA