Hello there,
Please, I need help, as I have a worksheet with a huge range of data reach up to 700k rows and more and some columns which have a function. due to the long range, I can't apply the function, as the worksheet take a long time to load, or it crashes. So I search for an effective way to find a final solution to save more time in waiting for the loading or fixing the crash.how Can I get the result through VBA model?
thanks in advance,
Please, I need help, as I have a worksheet with a huge range of data reach up to 700k rows and more and some columns which have a function. due to the long range, I can't apply the function, as the worksheet take a long time to load, or it crashes. So I search for an effective way to find a final solution to save more time in waiting for the loading or fixing the crash.how Can I get the result through VBA model?
thanks in advance,