Macros in Excel is what stuff it in the end

A macro is a set of instructions that tell EXCEL to complete the action specified by the user. Macro is similar to a computer program, but it is being fully operational in EXCEL, we can use a macro to complete the tedious, often repetitive work. Macro to complete the action faster than users themselves do much faster. For example, we can create a macro for each row of the worksheet, enter a date and in each cell within the center-aligned date and format of this border-line application. We can also create a macro, in the "Page Setup" dialog box, specify the print settings and print the document.
Because the impact of macro viruses and the fear of mental programming, many people dare not use the "macro", or do not know when to look for a macro to help. In fact, you may rest assured bold to use, if you only use the "record macro" approach, there are not any hard, just as some operations as recorded by tape recorder, to the use of the time, just run the macro, the system will put the operation and run it again.

Here are the macro applications, as long as the "Record Macro" to help you complete the task, without the need for programming. If you want the recorded macro and then edit it, we should have some knowledge of VBA.

* Set a table for each job requires a fixed form of the header;

* Set the cell into a form has its own style;

* Each print page setup are fixed;

* Frequently or repeatedly enter some fixed content, such as a good format for exclusive business address, personnel lists, etc.;

* Create a formatted table;

* Insert a worksheet or workbook and so on.

Should be noted that, EXCEL and WORD macros in the macro some differences, for the recording operation, it will remember the coordinates of the cell (ie, all references are absolute), so when it comes to position- The operation, to be extra attention. If the phase by using relative references, can be Offset by means of methods, such as the following statement: ActiveCell.Offset (1,0). Range ("A1"). Select the application macro is very wide, just a little bit above, If used together, you will find it to have more content and more flexible application methods.