I need my Macro to delete multiple rows at once.
For now I cycle it 1000 times deleting row by row and it works, but takes time to process.
For y = 1 To 1000
Rows(x - 1).Delete
Next
The problem mainly is that rows have to be designated by x that macro calculates earlier
Making it cycle 500 times with
Rows(x - 1).Delete
Rows(x).Delete
Doesnt reallly lower processing time as it still works one by one.
Being able to select multiple rows at once and delete them this way would greatly help me