Formula returning false when it shouldn't

[Paul_Hossler]

If that works out, I noticed that it looks like you could have 100 buttons in A and B on "1", with the only difference being the virtually identical 1 of 100 macros

Maybe using a worksheet event hander to process a double click in A4, B4, A5, B5, .... would be easier

Option Explicit
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Dim r As Long, c As Long
    
    With Target.Cells(1, 1)
        r = .Row
        c = .Column
    End With
    
    If r < 4 Or r > 50 Then Exit Sub
    If Len(Me.Cells(r, 4).Value) = 0 Then Exit Sub
        
    If c = 1 Then
        Call Application.Goto(Worksheets(CStr(r)).Range("A49"), True)
    ElseIf c = 2 Then
        Call Application.Goto(Worksheets(CStr(r)).Range("A75"), True)
    End If
End Sub

I accidently deleted the "Home" button macro