VBA Code to Highlight Named Ranges

Posted by admin on 2023-01-02 15:24:03 |

Share: Facebook | Twitter | Whatsapp | Linkedin Visits: 1112

VBA Code to Highlight Named Ranges

Sub HighlightRanges()
Dim RangeName As Name
Dim HighlightRange As Range
On Error Resume Next
For Each RangeName In ActiveWorkbook.Names
Set HighlightRange = RangeName.RefersToRange
HighlightRange.Interior.ColorIndex = 36
Next RangeName
End Sub