I need help about macro

[serkanozden]

I have an excel macro file about my lesson.
But it does not work properly.
Anybody help me about solving the problem of macro?

İt gives an error about out of range.
If the macro works properly, it finally exports a report that contains the analysis result values.

Macro Files Link;
https://wetransfer.com/downloads/28c...7081510/e20bee