excel宏选中第几行的代码

Question

选中第1行的代码是Rows("1:1").Select
如果是变量，选中第k到k+p行的代码是什么?
只需要这一句的代码，谢谢大侠

Answer 1

Rows(k & ":" & k+p).Select
试一试
补充
Sub aa()
Application.ScreenUpdating = False
For k = 1 To 4
Sheets(k).Select
w = 3
Do While Not IsEmpty(Cells(w, 1))
w = w + 1
Loop

j = 3
For i = 3 To w - 1
aCount = WorksheetFunction.Text(Cells(i, 6), "0")
Range("A" & i & ":G" & i).Select
Selection.Copy
Sheets(k + 4).Select
Range("A" & j & ":G" & j + aCount - 1).Select
ActiveSheet.Paste

j = j + aCount
Sheets(k).Select
Next
Next
Application.ScreenUpdating = False
End Sub本回答被提问者采纳