Macros: How to deal with big amount of data.

Hello.

I am trying to build a Macro for tasks scope and the amount of rows I have to extract the data from is really high. I am trying to extract all the receivables from them.
I have the feeling that the macro gets stuck (returns a general error) due to the amount of data it is dealing with (I am returning the rows as text in the browser).

Is there a way to debug or to deal with this amount of data when it comes to macros?

Thanks a lot for your time.
My best regards.
Juan.