Question
Write code to do the following: Make A1 the active cell Offset 3 rows and 2 columns, and make that the new active cell Set
Write code to do the following:
Make A1 the active cell
Offset 3 rows and 2 columns, and make that the new active cell
Set the value of the new active cell equal to your first name
Offset 3 rows and -2 columns, and make that the new active cell
Set the value of the new active cell equal to your last name
Make the cell furthest up from the current active cell the new active cell (use .end)
Set the value of the new active cell equal to your professors last name
Activate Sheet2
Set the value of cell A1 equal to your desired or current major
Make all of this code run in a single subroutine that is triggered by a button somewhere on the first worksheet.
When it is completed, upload your saved workbook below.
Be sure to write your code in a module in the workbook you will submit, not in your personal workbooks or sheets. To access the correct module, go to your Visual Basic, right-click Microsoft Excel Objects in the workbook you are submitting, and then click Insert and Module.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started