how can i speed up vba with 400k excel linest calculation

[MOSHEBS]

good day

please advise how can i speed up vba with 400k lines excel linest calculation
now it takes me about 12 hours to run.

1.how can i enter the excel formula linest to be calculated at the vba.
2.how can i speed up the program as it is evaulating
400,000 total lines
thanks for your help

mbs

[Marcol]

Duplicate Post?
linest formula at vba