macro to be faster

[mhax]

Hi,

I just made that code, and i saw that it's really slow. So i tried to find if there was a fastest way to right that kind of macro! thanks for helping me! So when i add a new object with the userform it add around 6000 cells(366 rows(for each day of the year) x 17 columns(some with formulas, others with info from userform))

Please Login or Register  to view this content.

[mudraker]

Turn off calculation at the start of the macro & back on at the end

Please Login or Register  to view this content.

or make your code more efficient by

replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

replace your for loop to single line comands

this from within the for loop

Please Login or Register  to view this content.

becomes

Please Login or Register  to view this content.

Apply similar changes to the other lines of code within the for loop

[mhax]

i get an error on that line you gave me, and i dont know why :S! everything seems to work!

Please Login or Register  to view this content.

[mhax]

i heard that array are way faster than loop! anybody got an idea for doing that loop but with arrays?
thanks

[mhax]

anyone????