To demonstrate your competence with navigating a worksheet with VBA, download the Excel workbook file below, Lastname.VBA.Navigation.HW$.$xlsm$.$ Name the file using your last name. For example, a student with the last name of Jones would name the file Jones.VBA.Navigation.HW$.$xlsm $($use your last name$).$ Then, complete the steps below, writing your code in Module$1,$ which has already been created for you.

Write code $($rather than recording a macro$)$ to do the following:

Make E$6$ the active cell

Set the value of the active cell to "CIS $200"$

Offset $2$ rows and $-3$ columns, and make that the new active cell

Set the value of the new active cell equal to your last name

Offset $-2$ rows and $2$ columns, and make that the new active cell

Set the value of the new active cell equal to your first name

Make the cell furthest up from the current active cell the new active cell $($use $.$end$($xlUp$))$

Set the value of the new active cell equal to your professor$$s last name

Activate Sheet$2$

Set the value of cell A$1$ equal to your desired or current major

Return to cell A$1$ on Sheet$1$

Make all of this code run in a single subroutine that is triggered by the button on the first worksheet.

When it is completed, upload your saved workbook below.

Be sure to write your code in Module$1$ in the workbook you will submit.