Using The Visual Basic Editor

r,x1

ra

Private Sub add() 1 add Macro

1 Macro recorded 5/19/2001 by Jinjer Simon

1 Keyboard Shortcut: Ctrl+d

ActiveCell.FormulaR1C1 = "=SUM(RC[-6]:RC[-1])"

End Sub

■ You may need to insert a blank line.

Click Delete to remove the macro.

± Close the Macro dialog box.

-0 In the Project Explorer click the module that contains the code for the macro you want to update.

—Q Place the cursor between the last line of code and the End Sub command.

■ You may need to insert a blank line.

—0 Close the Visual Basic Editor.

-, In the Macro dialog box, click the second-to-last macro.

Click Delete to remove the macro.

± Close the Macro dialog box.

■ When you run the macro, Excel executes the original and copied code.

0 0

Post a comment