How can I copy multiple select cells in Excel 2007 then paste into Windows Notepad?

I've been looking for a method to copy select cells from an Excel 2007 worksheet. I got this link:
https://support.microsoft.com/en-us/office/copy-visible-cells-only-6e3a1f01-2884-4332-b262-8b814412847e
...and followed it. Unfortunately, an issue showed up: when it went into the part of copying the cells I highlighted, I got an error message saying "The command cannot be used on multiple selections".

Browsed through this forum and came up this thread:
https://www.excelforum.com/excel-programming-vba-macros/1345272-need-help-getting-macro-to-loop-through-copying-and-pasting-a-range-of-cells.html

I was interested in a VBA script code made by member, LeoTaxi. Here it is below:

Sub test()
Dim arr As Variant, sn As Variant, x As Long, lr As Long
arr = Sheets("Organized Data").Range("A2", "I13")
With Sheets("Sheet2")
    lr = .Range("A" & .Rows.Count).End(xlUp).Row
    sn = .Range("A2", "A" & lr)
    For x = 1 To UBound(sn)
        Sheets("Organized Data").Range("A" & Rows.Count).End(xlUp).Offset(1).Resize(UBound(arr), UBound(arr, 2)) = arr
        Sheets("Organized Data").Range("A" & Rows.Count).End(xlUp).Offset(1) = sn(x, 1)
    Next
End With
End Sub

Questions:

1) Is there a way to modify LeoTaxi's code that can pop up a dialog box asking me what cell values I want to copy only to clipboard (like for example, "1,2,3,4,5" or "6,7,8") which I can later paste into Notepad?

2) If modifying that code is not possible, is there any way I can copy only the multiple cells I selected then paste into Notepad?