I have found that when manipulating a lot of data, VBA is the best since does not generate any background calculation sometimes unnecessarily. Yet although not 100% sure what if you turn calculation to manual?