Sub demo()
rs = Sheets(1).[c65536].End(xlUp).Row
If rs < 4 Then Exit Sub
With Sheets(4)
r = .[a:a].Find(What:="*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
Sheets(1).Range("c4:z" & rs).Copy
.Range("a" & r + 1).PasteSpecial Paste:=xlPasteValues
End With
End Sub
我这边代码本来是这样的:
Sub lu()
With Sheets("录入")
r = .Range("b65536").End(xlUp).Row + 1
If r < 4 Then r = 4
rs = Range("a65536").End(xlUp).Row
If rs < 4 Then Exit Sub
Range("a4:aa" & rs).Copy .Range("b" & r)
For x = r To r + rs - 4
.Range("a" & x) = .Range("a" & x - 1) + 1
Next
End With
MsgBox "录入完成"
End Sub
但是点击录入后,图一里到AA列的信息除红框外其它都能录到录入这个工作表中。按照你的意见改为如下公式:
Sub lu()
rs = Sheets(1).[c65536].End(xlUp).Row
If rs < 4 Then Exit Sub
With Sheets(4)
r = .[a:a].Find(What:="*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
Sheets(1).Range("c4:z" & rs).Copy
.Range("a" & r + 1).PasteSpecial Paste:=xlPasteValues
End With
End Sub
Sub lu()
rs = Sheets(1).[c65536].End(xlUp).Row
If rs < 4 Then Exit Sub
With Sheets(4)
r = .[a:a].Find(What:="*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
Sheets(1).Range("a4:aa" & rs).Copy
.Range("a" & r + 1).PasteSpecial Paste:=xlPasteValues
End With
End Sub
Sub lu()
rs = sheets(1).[c65536].End(xlUp).Row
If rs < 4 Then Exit Sub
With Sheets("录入")
r = .[a:a].Find(What:="*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
Sheets(1).Range("a4:aa" & rs).Copy
.Range("a" & r + 1).PasteSpecial Paste:=xlPasteValues
End With
End Sub