We help IT Professionals succeed at work.

VBA - Excel 2010 question about properties

In this statement:  

salesSum = cells(2,1).value + cells (2,2).value

What does the ". value" mean/do?   What other options are available besides ".value"
Comment
Watch Question

Commented:
A cell is an object.  The .<something> is a property of a cell.  You can set the colour, the border, the formula or indeed read the value by using .value.  You may find this page helpful ==> http://msdn.microsoft.com/en-us/library/ee814737.aspx

Priz
Michael FowlerSolutions Consultant
Commented:
The .value gives the contents of the range (ie Cells(2, 1)) if the the provided range is a single cell

Some other properties for Range (or Cells)  can be found at

http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.range_properties%28v=office.11%29.aspx

Michael