The .Text Property Causes Code to Execute Slower and Slower

I've recently found out that using the .Text property to get the text of a cell when looping through records causes the code to get progressively slower and slower until it's almost crawling, whereas getting just the cell's value doesn't exhibit any performance problems. What's the cause of this?

Example: I have 20,000 records, looping through them, getting the .Text property of a cell in column A, doing some processing with it. First 10,000 records go pretty quickly, then it starts slowing down more and more until, by the end, it's going at about 100 records/second as apposed to 1000 records/second. Simply removing the .Text property makes it fast all the way through. So what's the memory leak or whatever it is with the Text property?
I have posted an analysis and comparison of .Text .Value and .Value2 at

1 person found this reply helpful


Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.


Question Info

Last updated May 8, 2020 Views 646 Applies to: