In "Auto Member" drop down list of Range object I noticed Value2 property.
Question: what's the practical using of this property and in what cases it preferable to use?

Hi sektor,
Here's a piece of documentation from http://www.decisionmodels.com/calcsecretsj.htm
It is faster (15-20%) to use the Range.Value2 property rather than the (default) Range.Value property. The Range.Value property attempts to convert cells formatted as Dates to a variant containg a VBA date type, and cells formatted as currency to a variant containing a VBA Currency type. Range.value2 attempts to convert date and Currency formatted cells into Variants containing Doubles.

What it means in practical terms is that you might as well forget it exists...
I would consider it only on a full-scale scientific project with many thousands of Date and Currency calculations and conversions going back and forth, just to save myself of some extra seconds of waiting...