Help please.. This works but, I want to be able to double click
anywhere in the same row and activate the same target(in column 2). I
currently have 223 columns.
Is this possible?



Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
Cancel = True

Worksheets(Target.Offset(0, -15).Value).Activate

End Sub



Thanks in advance,

Marc