Is ".Value" important ?

[alextang0112]

Hi guys,

What's the difference between .cells(1.1).value and .cells(1.1) ?

Is it true that in most cases they work the same ?

Thank you.

 

[asif_raza]

.cells(1.1) it can refer to anything.. value, formula, format and other formats as well. but when you say .cells(1.1).value you are referring to values attribute of cell only.
e.g. If you copy a column contain some formula and just paste as CTRL+V then you would see there are some values different than original (because of formula) but if you paste copied data using pastespecial->values then you will have same data as copied.

 

[Kyle123]

In most cases, then yes, they will behave the same, this is because the default property of .cells(1.1) is .value , so referring .cells(1,1) will usually return its value it is however not encouraged. The problem is that this is dependant on how it is used, for example:

Sub test()
    a = Range("a1:a5") 
    Set b = Range("a1:a5")
End Sub

a is not the same as b, a is an array whereas b is a range object. It's therefore useful to be explicit in what you mean.

.cells(1,1) returns a range object, this object has a ton of properties and methods, formula text etc etc... only one of which is value, but since ms believe that this is the most commonly requested property they have set it as the default property of the range object.