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...

Exam 77-888: Microsoft Excel Expert 2010

4. Working with Macros and Forms

4.1. Create and manipulate macros.

Developer ->Code-> Relative References