Rewrite VBA code to reduce execution time

I have written a VBA code for a large data set. I would like you to refactor it in order to improve the execution time.

For instance:

- Execute the data set in an array rather than copying each data point
- Avoiding copy and paste
- Etc..