You can open X instances of excel to the amount of cores in your pc. Set each excel instance to a different core. Then run a set range on each one. Once they are all finished copy them back into 1 sheet and do what you need.

Consider posting the original code. There might be a more efficient way to handle your calculation that doesn't involve nested loops.