peace,
how to modify this code so that the same functionality that E1 and F1 has can also be duplicated to E2, F2, E3 and F3. In other words how to add more cells than just E1 and F1 to it. . .
will appreciate help!!
Code:
Sub insert()
Dim start As Long
Dim rows As Long
start = Range("E1")
rows = Range("F1")
Cells(start, 1).Resize(rows).EntireRow.insert
End Sub
how to modify this code so that the same functionality that E1 and F1 has can also be duplicated to E2, F2, E3 and F3. In other words how to add more cells than just E1 and F1 to it. . .
will appreciate help!!