Speed up if...next VBA

Dear all,

having this macro involved in my list, it takes ages until it is done (200 sec aprox.). As it should be just a part of longer macro, I need to figure out, how to speed it up.
Any idea I can understand? ( I am macro begginers. :-) )

This code should be instead of VLOOKUP function. TREndRow has value 1500, PocetBridge around 4000. It goes one by one - I thing that is why is is so slow.

Please Login or Register  to view this content.

Hi olwy,

it would help us if you had a sample workbook to post, we always work better if we can see the spreadsheet and experiment with solutions

Jmac1947

Here is the file where I need it - it is without company data, so it looks a litte bit strange.
If anybody has more time, please, check, how could I replace all formulas in green. Normally, they are on each row.
(run macro separatelly, my composed macro will not work - as the Trial balance sheet is deleted.

Thanks a lot for any hint.
UpFile makrohrátky - funkční 01 - Copy.xlsm

Hi Olwy,
try it

Please Login or Register  to view this content.

Holly crab,
you are genious. It takes less than wink. I cannot count it on seconds. Great, I am going to study, what has happend.
Olwy