With Me.Spreadsheet1
arr = .ActiveSheet.UsedRange
If Not IsEmpty(arr) Then
Range(.ActiveSheet.UsedRange(1).Address).Resize(UBound(arr), UBound(arr, 2)) = arr
End If
End With



|
![]()
Dim arr
With Me.Spreadsheet1 arr = .ActiveSheet.UsedRange If Not IsEmpty(arr) Then Range(.ActiveSheet.UsedRange(1).Address).Resize(UBound(arr), UBound(arr, 2)) = arr End If End With ![]() ![]() ![]() 暂时没有评论
|