Dim i%, a% i = 0 a = 2 Do ActiveSheet.Cells(a + i, 1).Select Application.CutCopyMode = False Selection.Copy Sheets("出库单").Select ActiveSheet.Cells(a + 13 * i, 4).Select ActiveSheet.Paste Sheets("整理模板").Select i = i + 1 Loop Until i = 14目前我是用i来实现循环,但是需要手动修改。我希望达到自动判定有内容的最后一行,有大神能给点思路吗,没有的话我再找找
i = 0
a = 2
Do
ActiveSheet.Cells(a + i, 1).Select
Application.CutCopyMode = False
Selection.Copy
Sheets("出库单").Select
ActiveSheet.Cells(a + 13 * i, 4).Select
ActiveSheet.Paste
Sheets("整理模板").Select
i = i + 1
Loop Until i = 14目前我是用i来实现循环,但是需要手动修改。我希望达到自动判定有内容的最后一行,有大神能给点思路吗,没有的话我再找找