If you use VBA the use of Excelformulae like 'Vlookup' is redundant and slowing down the calculations dramatically.