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.