Question: Can you help me with this code? To demonstrate your competence with navigating a worksheet with VBA, create a workbook named whatever you want (dont

Can you help me with this code?

To demonstrate your competence with navigating a worksheet with VBA, create a workbook named whatever you want (dont forget to save as macro-enabled: .xlsm), and do the following.

  1. Write code to do the following:
    1. Make A1 the active cell.
    2. Offset 3 rows and 2 columns, and make that the new active cell
      1. Set the value of the new active cell equal to your first name
    3. Offset 3 rows and -2 columns, and make that the new active cell
      1. Set the value of the new active cell equal to your last name
    4. Make the cell furthest up from the current active cell the new active cell (use .end)
      1. Set the value of the new active cell equal to your professors last name.
    5. Activate Sheet2
      1. Set the value of cell A1 equal to your desired or current major.
  2. Make all of this code run in a single Sub that is triggered by a button somewhere on the 1st worksheet.

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!