edsonpaula
New Member
- Joined
- Mar 22, 2021
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
Hello,
I need to create a macro to delete rows from A3 till the last line for specifics sheets (that I'll specify in the macro), I have created a macro for delete, but I'm having trouble creating a macro that runs this deletion for a range of sheets.
perhaps there is a better way of doing it.
here the code that I create for the deletion
Thank you very much
I need to create a macro to delete rows from A3 till the last line for specifics sheets (that I'll specify in the macro), I have created a macro for delete, but I'm having trouble creating a macro that runs this deletion for a range of sheets.
perhaps there is a better way of doing it.
here the code that I create for the deletion
VBA Code:
Private Sub DeleteRows()
Range("A3:AC3").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.EntireRow.Delete
End Sub
Thank you very much