Code advances VERY SLOWLY and blocks after 3 columns of calculations

[seigna]

Hi,

I have constructed a code for the GARCH financial model basing myself on a template that in fact, first, for 1st column, is VERY slow! Takes some 6-7 minutes to run... (how could I make it more efficient)?

And, for the third column Rentabilites it goes way down and gives me back an error.. while I want it to stop at the last data...

Does anyone have a clue how to fix this?

Please Login or Register  to view this content.

[seigna]

The code for module 2 is up there.

[AB33]

Please Login or Register  to view this content.

Get rid of "Selection"

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Use lastrow instead of fixed loop as your code may not need to go all the way down to 1266, if You have not got data.

[seigna]

Do you mean I should use End(xlUp)?

[AB33]

Yes, that is right

[seigna]

In those lines where I deleted select?

[AB33]

Generally when you loop through, avoid using a fixed looping range, use lastrow, so the code will not go to the last fixed loop if there are not data.

[seigna]

I can't see how exactly to do it.. :S

[seigna]

How could I rewrite this?

Please Login or Register  to view this content.

[seigna]

And , the first values aren't placed in the column either...

[AB33]

I do not know as you have many selection, but to give some idea

Please Login or Register  to view this content.

[seigna]

And how would I integrate the formula in here?