Slow VBA execution

Hi all

I hope you can help me shed some light over this problem.

I have a worksheet (Excel 2010) where I want to re-number the records in a table. There are always about 12000 records.
In the workbook there are a lot of Vlookup's that refer to this table.

My macro uses about 20 sec to renumber 100 records, which makes this solution unapplicable. In a new sheet it takes only a split second.

I tried to disable automatic calculation to fix the issue, but it doesn't really help.

Any clues?

Please Login or Register  to view this content.

Br Michael

Please Login or Register  to view this content.

INTO may help

Please Login or Register  to view this content.

Actually the whole workbook is very slow for some reason, when I set LastRow= 40 it is still killing me.

I hope to make a work-around by disabling automatic calculation, but i seems that I have to rebuild the workbook step by step to see where the mishab is.
I was just hoping to be able to avoid this.

GustavBA,

does this provide any improvement?

Please Login or Register  to view this content.