Sub 插入() Dim rw%, sr$, ss For rw = 2 To WorksheetFunction.CountA([a:a]) sr = sr & rw & ":" & rw & "," Next rw sr = Left(sr, Len(sr) - 1) End Sub