i tried this macro to not use range select. Instead of clicking cells in table, macro clicks below active cell vertically

Sub RefreshAll_LinkClickable_v2()

    Application.ScreenUpdating = False
    ActiveWorkbook.RefreshAll

    Dim ws As Worksheet
    Dim rRng As Range
    Set ws = ActiveSheet
    Set rRng = ws.Range("ControlTable[Borrower]:ControlTable[Agreement], ControlTable[Date of Balance Confirmation], ControlTable[The last related Document]")

    Dim rCell As Range
        For Each rCell In rRng
            Application.SendKeys "{F2}"
            Application.SendKeys "{ENTER}"
        Next rCell

    Application.ScreenUpdating = True
    
End Sub