轉換器無法打開文件excel如何辦

方法

打開要編輯的excel表

選中要複製的單元格

在菜單欄中選擇【視圖】

點擊【宏】

選擇【錄製宏】

取號名字後，點擊【確定】即開始錄製

然後在開發工具中點擊【停止錄製】，即錄製了一空白宏

最後按住【alt+f11】，打開一VBA窗口。在窗口中輸入以下代碼，按Alt+F11打開VBA界面，並將下述代碼更新在“個人宏工作簿”的模塊中。
Sub 多區域複製粘貼()On Error Resume Next
Dim SRange() As Range, UPRange As Range, TRange As Range
Dim i As Long, AreaNum As Long
Dim MinR As Long, MinC As Long
AreaNum = Selection.Areas.Count
ReDim SRange(1 To AreaNum)
MinR = ActiveSheet.Rows.Count
MinC = ActiveSheet.Columns.Count
For i = 1 To AreaNum
Set SRange(i) = Selection.Areas(i)
If SRange(i).Row < MinR Then MinR = SRange(i).Row
If SRange(i).Column < MinC Then MinC = SRange(i).Column
Next i
Set UPRange = Cells(SRange(1).Row, SRange(1).Column)
Set TRange = Application.InputBox(prompt:="選擇粘貼區域的最左上角單元格", Title:="多區域複製粘貼", Type:=8)
Application.ScreenUpdating = False
For i = 1 To AreaNum
SRange(i).Copy
TRange.Offset(SRange(i).Row - MinR, SRange(i).Column - MinC).PasteSpecial paste:=xlPasteValues
Next i
Application.ScreenUpdating = True
End Sub即可