Is “Value” actually the default property of the Range object?

by

The default member of the Range class is called _Default and is hidden. When you enable the “Show Hidden Members” feature in the Object Browser you can see it:

VBA Object Browser

It has the exact same signature as the .Item property, so one of them is arguably an alias for the other.(*)

In any case, Range also implements the collection interface. As such, it can be used in a For Each loop — and when you do that, the loop will call .Item with each iteration and assign the current item to the loop variable.

When used outside an enumeration, for example with Debug.Print, then .Value will be used, but I can’t really explain why. Maybe someone else can come up with a hint.(*)

(*) As @GSerg points out in the comments, _Default() and _Item() are not exactly equal.

More Related Contents:

  1. VBA code takes long time to execute in excel
  2. Does VBA have Dictionary Structure?
  3. Get reference to additional Inbox
  4. VBA, ADO.Connection and query parameters
  5. Save text file UTF-8 encoded with VBA
  6. Outlook VBA – Run a code every half an hour
  7. Is it possible to pass parameters programmatically in a Microsoft Access update query?
  8. Hidden features of VBA
  9. What is the lifetime of a global variable in excel vba?
  10. Difference between Visual Basic 6.0 and VBA
  11. Download attachment from Outlook and Open in Excel
  12. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  13. VBA: Selecting range by variables
  14. Use autofilter on more than 2 criteria
  15. How do I display a messagebox with unicode characters in VBA?
  16. Calling a Sub in VBA
  17. Open an html page in default browser with VBA?
  18. Is it better to use ADO or DAO in Access 2007?
  19. Open a workbook using FileDialog and manipulate it in Excel VBA
  20. Excel VBA – Combine rows with duplicate values in one cell and merge values in other cell
  21. Load csv file into a VBA array rather than Excel Sheet
  22. MS Access: how to compact current database in VBA
  23. VBA Macro crashes after 32000 rows
  24. Determine real cause of ODBC failure (error 3146) with ms-access?
  25. How to break a long string into multiple lines
  26. How to comment and uncomment blocks of code in the Office VBA Editor
  27. finding latest file in a folder and opening it (vba access)
  28. reading and writing a csv file using FileSystemObject
  29. How to have vba execute every 10 minutes?
  30. Read and write from/to registry in VBA

Leave a Comment