Question: 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

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 workbook, so that you dont have to qualify the references by worksheet or workbook. (Hint: You can reference the ranges by using the Select method. e.g., Range(A2:C4).Select.) Before you begin, create a range name in Excel called Profit that covers range D3:Q32. You can test your program one line at a time by pressing the key in the Visual Basic Editor. (a) The fourth cell of the range E2:E17. (b) The cell at the intersection of the 6th row and 4th column of a range that has the range name Profit. (c) The cell at the intersection of 23rd row and 8th column of a range that has been set to the Range object variable totalProfit. Have totalProfit cover A5:M50. (d) The cell at the intersection of the 10th row and 24nd column of A1:AA1000. (e) The entire row corresponding to cell F5. (f) The set of entire columns from column C through column K. (g) A range of country names, assuming the first is in Cell B3 and they extend down column B (although you dont know how many there are). [You will need to enter a range of names to test this.] (h) A range of inventory figures in a rectangular block, assuming that location labels are above them in row 1 (starting in Cell E1) and week labels are to their left in column D (starting in Cell D2). You dont know how many locations or weeks there are, and you want the range to include only the sales figures, not the labels. [You will need to enter data to test this.] (i) The cell that is 15 rows down from and 3 columns to the right of the active cell. (The active cell is the cell currently selected. If a 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 as ActiveCell.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!