Edit the Macros Animation tutorial in an Excel table

Excel2003 Introductory Animation Tutorial 58, edit macros in Excel tables.

Demo Animation

Operation Steps

If you are familiar with the language of the VBA program, you can edit the macro directly in Excel is more convenient, the macro code is also simpler.

Go to the Visual Basic Editor window by executing the tools → macros →visual basic Editor command.

In the Project Explorer window on the left, select the workbook where you saved the macro, and then follow the Insert → module command to insert a new module (Module 1).

Enter or copy and paste the relevant macro code into the editing window on the right.

Note: The structure of the macro is:

SUB Macro Name ()

Related code

End Sub

When the input is complete, close the Visual Basic Editor window and return.

In this case, we directly edit the macro to delete the first 4 columns of the current row of cells, and the system does not give relevant hints. Let's run a look at the effect.