02 - Range Properties Quiz

The correct syntax for making Cell A1 bold is

Range("A1").Font = Bold

The default property for a Range is :

If you wanted to get the Absolute address (with all the dollar signs aka $A$1) of cell A1, you would type the following. . .

To have Excel Select a certain cell or range, such as our "tax_table", you'd type

Range("tax_table").Select

In the following example:

These two lines of code will return the same data from cell A1 in a Message Box:

Msgbox Range(“a1”).Value

and

Msgbox Range(“a1”).Text

It is possible to assign a formula to a cell using VB and then take the output from the formula and assign it to the same cell; basically replacing the formula (so an edit in values used for the calculation will not change the value in the cell for the future).

To code a range of numbers to be formatted for percentages with TWO decimal places, which code would be correct?

The COUNT property for a range will display the total of all the values in the cells of the range.