https://alfredmyers.com/2009/02/12/you-probably-shouldnt-be-using-redim-preserve-inside-a-loop/
You probably shouldn’t be using ReDim Preserve inside a loop