Get Range Address When Length Of Address Greater than 251 / 255

[Rasm]

I am trying to capture a

Selection.Address property

That is longer than 255 characters - So the user selects rows using the mouse (shift+click & Ctrl+click).
When the user is done selecting the rows - I have a userform with actions - i.e. exporting the selected rows.

BUT - the Selection.address stops changing at around 251 characters (I added a label that displays the value and the length) - any suggestions how I can trap the selections into and array or something - so the user can make a selection that is any length.

My main objective is to allow the user to select any number of rows - then select the type action he wants to do with the selection - i.e. Export of data or charting. So if anybody has other suggestions - it is much appreciated.

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
    If Len(Selection.Address) > 251 Then
        MsgBox "How to deal with this"
    End If
end usb

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA