Create Another Macro
The first macro used Absolute Cell References.
You can also use Relative Cell References when you
record your Macro.
Relative References
means the new Row will be added below any Cell that is selected when
you run the Macro.
Before
You Begin: Minimize Visual Basic.
You should
see your spreadsheet.
Delete
the Sample Rows
Go to the
Legs spreadsheet.
Delete Row 21 and 22 (the new rows).
Use
Relative References
Go to
Developer->Code.
Click on
Use Relative References.
7.
Try it: Create Another Macro
Go to
Developer ->Code.
Click on Record Macro.
Type a
Macro Name:
AddNewRow2
Store
macro in: This Workbook.
Description: Type a sample description.
Click
OK. Keep
going...