I have a macro that takes ~22 seconds to run and ~18 of those seconds are in this piece of code:
For A = x To Z Step -1
If Cells(A, 3) = "" And Cells(A, 4) = "" And Cells(A, 5) = "" And Cells(A, 6) = "" And Cells(A, 7) = "" And Cells(A, 8) = "" And Cells(A, 9) = "" And Cells(A, 10) = ""...