What is the difference between .text, .value, and .value2?

by

.Text gives you a string representing what is displayed on the screen for the cell. Using .Text is usually a bad idea because you could get ####

.Value2 gives you the underlying value of the cell (could be empty, string, error, number (double) or boolean)

.Value gives you the same as .Value2 except if the cell was formatted as currency or date it gives you a VBA currency (which may truncate decimal places) or VBA date.

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

More Related Contents:

  1. Want to concatenate multiple row data in in cell along with its values if present. Emp Id should not come if no data available infromt of it
  2. I am confused on purpose of using “Not”, also on matching of “If” criteria, code says “is nothing” else run code for “MsgBox”
  3. How to copy a line in excel using a specific word and pasting to another excel sheet?
  4. Excel VBA – How to add dynamic array formula
  5. Check if the file exists using VBA
  6. How can I create a progress bar in Excel VBA?
  7. Compare double in VBA precision problem
  8. Row count on the Filtered data
  9. Excel VBA Macro: User Defined Type Not Defined
  10. Automate IE via Excel to fill in a dropdown and continue
  11. Run-Time error 1004 Excel 2013
  12. VBA – Write all possible combinations of 4 columns of data [duplicate]
  13. Excel VBA to Export Selected Sheets to PDF
  14. Remove duplicates from array using VBA
  15. Controlling Internet Explorer local intranet using Excel VBA
  16. How to automatically insert a blank row after a group of data
  17. Count unique values in Excel
  18. Get File Path (ends with folder)
  19. Get length of array?
  20. Email a single attachment from folder of files each to a different person
  21. Bad data selection using VBScript , on date field values
  22. Sending object array to variant works before August 2019 Windows update, but fails after update
  23. Find last row in range
  24. Differences between Excel’s Form Controls & ActiveX Controls
  25. Excel VBA User Defined Function that counts cells with conditional formatting
  26. Excel is calculating a formula with a VBA function as an error unless it is re-entered
  27. SAP Extract into EXCEL via VBA out of memory
  28. reading entire text file using vba
  29. How to roundup a number to the closest ten?
  30. Convert month name into number

Leave a Comment