Microsoft Excel 5C: Range and Cells Methods of Selecting Cells, Declaring Variables, =Now()

Range Method:

• Sometimes your program may want to refer to certain cells.
• If the program always refers to these certain cells, you may use the range method.
• Example: Range("B1").Select
  • In the above example, when this line of code is read by the program cell B1 will be highlighted.

Cells Method:

• The cells method is the same thing as the range method only written a little differently.
  • Example: to select the same cell B1 in the previous method, the cells method is: Cells(1,2).Select

Range Method (multiple cells):

• The range method can be used to highlight several cells, for example to highlight cells B1 to B5 the range method would be: Range("B1:B5").Select

Note: this all makes a bit more sense when you actually use these methods in your program, like you will when you do the assignment.

 

 

This website is copyright protected see contact page for details. .