比如
Dim str As String = ""For Each r As Row In Tables("表A").Rows str &= r("第二列") & vbcrlfNext
ClipBoard.settext(str)