Sub 保存()
Dim rng As Range, ws As Worksheet, rngs As Range
For Each ws In Worksheets
If ws.Name = Range("q1") Then
Set rng = Range("i1", [o1].End(xlDown)(1.1))
Set rngs = ws.Cells([a1].End(xlDown)(1.1), "a")
rng.Copy rngs
End If
Next ws
End Sub
这是我写的代码,为什么复制过去后是在A48380单元格向下复制的?
你是不是这个意思Set rng = Range([i1], [o1].End(xlDown))