Question: Q 1 . Write a reference, in VBA code, to each of the following ranges. ( You can assume that each of these ranges is

Q1. 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.) Heres an example. Question: The cell one column to the right and two rows below Cell A1. Answer: Range (A1).Offset(2,1)
The fifth cell of the range B1:B30.
The cell at the intersection of the 25th row and 5th column of the range A1:Z100.
The cell at the intersection of the 25th row and 5th column of the range that has been set to a Range object variable named SalesRange.
A range of employee names, assuming the first is in cell B2 and they extend down column B (although you dont know how many there are).Q1. 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.) Heres an example. Question: The cell one column to the right and two rows below Cell A1. Answer: Range (A1).Offset(2,1)
The fifth cell of the range B1:B30.
The cell at the intersection of the 25th row and 5th column of the range A1:Z100.
The cell at the intersection of the 25th row and 5th column of the range that has been set to a Range object variable named SalesRange.
A range of employee names, assuming the first is in cell B2 and they extend down column B (although you dont know how many there are).Q1. 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.) Heres an example. Question: The cell one column to the right and two rows below Cell A1. Answer: Range (A1).Offset(2,1)
The fifth cell of the range B1:B30.
The cell at the intersection of the 25th row and 5th column of the range A1:Z100.
The cell at the intersection of the 25th row and 5th column of the range that has been set to a Range object variable named SalesRange.
A range of employee names, assuming the first is in cell B2 and they extend down column B (although you dont know how many there are).Q1. 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.) Heres an example. Question: The cell one column to the right and two rows below Cell A1. Answer: Range (A1).Offset(2,1)
The fifth cell of the range B1:B30.
The cell at the intersection of the 25th row and 5th column of the range A1:Z100.
The cell at the intersection of the 25th row and 5th column of the range that has been set to a Range object variable named SalesRange.
A range of employee names, assuming the first is in cell B2 and they extend down column B (although you dont know how many there are).Q1. 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.) Heres an example. Question: The cell one column to the right and two rows below Cell A1. Answer: Range (A1).Offset(2,1)
The fifth cell of the range B1:B30.
The cell at the intersection of the 25th row and 5th column of the range A1:Z100.
The cell at the intersection of the 25th row and 5th column of the range that has been set to a Range object variable named SalesRange.
A range of employee names, assuming the first is in cell B2 and they extend down column B (although you dont know how many there are).

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 Databases Questions!