200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Dear Sirs,
In the attached file , I highlighted cell with a yellow background if another cells next to it on the same row has hyperlink manually.(i.e B2 with a yellow background if A2 has hyperlink).
I need help in repeating the same purpose to another cell by using macros (Vba) to prevent the repetitive action manually on other cells in the existing dynamic range of data.
Looking forward to having the help in this regards
Many thanks and best regards
Arsil Hadjar
Hi,
Please change range as per requirement,
Sub Hyperlink_Selection()
Dim Rng As Range
For Each Rng In Range("A3:A383")
If Rng.Hyperlinks.Count > 0 Then
Rng.Offset(0, 1).Interior.Color = vbYellow
End If
Next
End Sub