PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Sub delins(uCount As Integer, uMethod As Integer) 'Inserts or deletes a number of given rows based on count and rangename 'Method definition ' = Delete ' = Insert Dim i As Integer, n As Integer, m As Long, wks As Worksheet Set wks = ThisWorkbook.Sheets("Test") Set dCell = Range("testrow") Do While uCount > 0 n = dCell - 1 m = uRowNumber If n > 0 Then Rows(m + 1 & ":" & m + n).Insert Set dCell = dCell.Offset(n + 1, 0) Else Set dCell = dCell.Offset(1, 0) End If Loop End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.