We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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.
|EXCEL String-handling question ...||7||51|
|Need macro to assign two digit numbers to selected cells in Excel 2016||3||33|
|rename csv files in a folder||3||15|
|Assigning multiple macro in one command button||8||19|
Join the community of 500,000 technology professionals and ask your questions.