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