Question: I want this code change to A2 cell to A200 cell (Entire coloumn)
Range will be K2 to k200 : W2 to W200 please change the code and reply back.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = “$A$2” Then
Dim cell As Range
For Each cell In Range(“K2:W2”)
If cell <> “” Then
ActiveWorkbook.FollowHyperlink Address:=cell.Value
End If
Next cell
End If
End Sub
In code we mention particular cell but i want entire row and column will appear in same formula
New contributor
Jagadeesh Naidu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.