Loop alternatives or improvement for speed

I'm trying to manipulate some data on my sheet using loops. However it seems to be to slow to loop trough all cells when more than 1500 rows, and my sheet may be up to 50'000-100'000.

Is there any other way to solve this using something other than loops. Or may my loops be written better to improve performance?

Are there perhaps a way to combine these 3 loops into 1 to improve speed?

What I'm trying to do is to first delete rows so that I' ending up with some specified data. And then insert a row with formulas.

Please Login or Register  to view this content.

I have now tried to make me an temp new column "A" with an formula that fills blanks for all cells that I want to delete. And from this using a autofilter to delete unwanted rows.
And finaly then load the range in a varrary instead of the loop to insert some new values and formulas.

However this is even more slow than my initial code. Seems like especially when Im writing the formulas and values to the Offset cells is affecting performance quite alot.

Any suggestions to how this can be solved better?

Please Login or Register  to view this content.