/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 vote120 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote125 views1 answer
Vb test if reference is null
VBA
0 vote113 views1 answer
Vbnet add new ecel sheet
VBA
0 vote130 views1 answer
Vba type variable
VBA
0 vote122 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote123 views1 answer
Excel vba chrw max value
VBA
0 vote124 views1 answer
Vba get relative cell address
VBA
0 vote120 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
6 votes140 views1 answer
Excel vba get the path of current workbook
VBA
0 vote127 views1 answer
Excel vba automatic calculation
VBA