When this question was last asked it was wrong! Write a reference in (VBA code to each) of the following ranges. You can assume that each of these ranges is in the active worksheet of the active work work, so that you don't have to qualify the references by worksheet or workbook.

a. the third cell of the range A1:A10

b. the cell at the intersection of the 24th row and 10th column of a range A1:AZ500.

c. the cell at the intersection of the 24th row an d10th column of a range that has the range name Sales.

d. the cell at the intersection of the 24th row an d10column of a range that has been Set to the Range object variable sales Range.

e. the entire column corresponding to cell D7.

f. the set of entire columns from column D through column K.

g. a range of employee names, assuming the first is in cell A3 and they extend down column A (although you don't know how many there are.)

h. a range of sales figures in a rectangular block, assuming that region labels are to their left in column A (starting in cell A4) and month labels are above them in row 3 (starting in cell B3). you don't know how many regions or months there are and you want the range to include only the sales figures not the labels.

l. the cell that is 2 rows down from and 5 columns to the right of the active cell. ( the active cell is the cell currently selected. if the rectangular range is selected, the active cell is the first cell that was selected when the range was selected. It can always be referred to in VBA active Cell).

Answer rating: 100% (QA)

a Workbook myworkbookSheetsSheet1RangeA1A10Item31 Font BoldTrue b Workbook myworkbookSheet... View the full answer