|
这段代码可以帮你导入数据
- Sub 导入数据()
- Dim SHT As Worksheet
- Dim K, X As Long
- Dim N, M As String
- N = ActiveSheet.Name
- M = ActiveWorkbook.Name
- For Each SHT In Sheets
- If Left(Right(M, 4), 1) = "x" Then
- X = 1048576
- Else
- X = 65536
- End If
- K = Sheets(N).Range("A" & X).End(xlUp).Row
- If SHT.Name <> N Then
- 行 = SHT.Range("A" & X).End(xlUp).Row
- 列 = SHT.Range("A1").End(xlToRight).Column
- SHT.Range("A1").Resize(1, 列).Copy Sheets(N).Range("A1")
- SHT.Range("A2").Resize(行, 列).Copy Sheets(N).Range("A" & K + 1)
- End If
- Next
- End Sub
复制代码 |
|