What is the difference between . text, . value, and . value2? Using Value or Text is usually a bad idea because you may not get the real value from the cell, and they are slower than Value2 For a more extensive discussion see my Text vs Value vs Value2