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"
brothertruffle880Asked:
Who is Participating?
 
Pr1zConnect With a Mentor 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
0
 
Michael FowlerConnect With a Mentor Solutions ConsultantCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.