RedOctoberKnight
Board Regular
- Joined
- Nov 16, 2015
- Messages
- 150
- Office Version
- 2016
- Platform
- Windows
Good Morning,
I have the following formula that i'm using to create horizontal tabs on a worksheet. I'm running into problems with merged cells which are the tabs. I'm not sure how to write the formula so that it accounts for the merged cells. The tabs are merged using cells E3:F4 for one, G3:H4 for another, and I3:J4 for the last.
Any help would be much appreciated. Thanks
I have the following formula that i'm using to create horizontal tabs on a worksheet. I'm running into problems with merged cells which are the tabs. I'm not sure how to write the formula so that it accounts for the merged cells. The tabs are merged using cells E3:F4 for one, G3:H4 for another, and I3:J4 for the last.
VBA Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.CountLarge > 1 Then Exit Sub
If Not Intersect(Target, Range("E3:J3")) Is Nothing Then
If Target.Column = 5 Then BOARDS_RAMP
If Target.Column = 6 Then BOARDS_CS
If Target.Column = 7 Then BOARDS_OPS
End If
End Sub
Any help would be much appreciated. Thanks