VBA is horrid and incredibly outdated. I’ve written c# code that ran identical calculations on data being run through excel at literally over a million times the speed.