Compare the Code

9. Try it: Review the Code

Go to Developer ->Code-> Macros.

Select a Macro: AddNewRow2.

Click on Edit.

 

What Do You See? The VBA Editor should open in a new window. There should be two Subroutines: AddNewRows () and AddNewRows2 ().

 
What Else Do You See? In this code ActiveCell is used to create a Relative Reference.

 

Try This As Well: Close the Editor

Go to File->Close and Return to Excel.

 

Very good.

Exam 77-888: Microsoft Excel Expert 2010

4. Working with Macros and Forms

4.1. Create and manipulate macros.

File->Close and Return to Excel