|
- Sub 下拉填充()
- Dim jRow&, zRow&
- Dim xColumn&, j&
- With Sheet1
- jRow = .Range("A1").End(xlDown).Row '计算A列向下最后一个非空行
- zRow = .Range("B1").End(xlDown).Row '计算B列向下最后一个非空行
- xColumn = 6 'B列到G列共6列
- If jRow > zRow Then
- For j = 1 To xColumn
- .Cells(zRow, j + 1).AutoFill Destination:=.Range(.Cells(zRow, j + 1), .Cells(jRow, j + 1)) '填充
- Next
- End If
- End With
- End Sub
复制代码
|
|