Como excluo um intervalo de linhas usando o VBA?
Excel VBA Examples for Deleting multiple Rows at time
The following example will delete Row 5 to 10 at a time from the active worksheet.
'In this Example I am deleting Rows 5 to 10 Sub sbDeleteARowMulti() Rows("5:10").Delete End Sub
Instructions
- Open an Excel Workbook
- Press Alt+F11 to open VBA Editor
- Insert a Module from Insert Menu
- Copy the above code and Paste in the code window
- Save the file as macro enabled workbook
- Press F5 to execute it