Open up Excel. Go to Cell E1 and use the Name Box to name this cell “Rain”. Then

Question

Open up Excel. Go to Cell E1 and use the Name Box to name this cell “Rain”. Then go to the Developer tab on the Ribbon, and click on the Record Macro button in the Code group. Name your macro “Referencing” and give it a shortcut key of “R”. After clicking OK to close the Record Macro Dialog Box, do the following:

Select Cell A4 using relative referencing (select the Use Relative Reference button).

Using the drop-down arrow to the right of the Name Box, select “Rain”.

Use absolute referencing (de-select the Use Relative Reference button) to select Cell H12.  

Click on the Stop Recording button in the Code group on the Developer tab.

After you have performed these steps, view your code in Visual Basic Editor, and answer the following questions:

What code was written when you selected Cell A2 using relative referencing?

What code was written when you selected the cell named “Rain” using the Name Box drop-down menu?

What code was written when you selected Cell H12 using absolute referencing?

Explanation / Answer

What code was written when you selected Cell A2 using relative referencing?

Range("A1:A6").Select

What code was written when you selected the cell named “Rain” using the Name Box drop-down menu?

Application.Goto Reference:="Rain"

What code was written when you selected Cell H12 using absolute referencing?

Range("H12").Select

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.