Advertisement
Guest User

Untitled

a guest
Apr 25th, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. Private Sub deleteRow(intCell As Integer) 'note: intCell is actually just the ROW
  2. Dim strRow As String
  3.  
  4. strRow = Trim(str(intCell)) & ":" & Trim(str(intCell))
  5. Rows(strRow).Select
  6. Selection.Delete Shift:=xlUp
  7.  
  8. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement