Excel Macros

Do you have common tasks that you perform over and over in Microsoft Excel  For instance, do you often apply the same combination of formats, or do you receive data every week or month that you organize and analyze the same way every time? You can use a macro to combine all of the steps in a task into a single command.

Solutin Is Using Excel Macros.

1. 
   
2. Point to Macro on the Tools menu, and then click Record New Macro.
3. In the Record Macro dialog box, type a name for the macro in the Macro name box. Macro names must start with a letter and can include letters, numbers, and underscore characters, but can't include spaces. You don't need to change the other boxes:

   When you click OK, the Stop Recording toolbar appears, and you're ready to record. Until you stop the recording, every Excel command and keystroke will be recorded in the macro, in the order in which they are entered.
   

4. Now format the cell the way your boss wants it flagged: click Cells on theFormat menu, click the Font tab, click Bold under Font style, click Red forColor, click the Border tab, click Red for Color, click the border thickness you want, click Outline, and then click OK.
5. To finish recording the macro, click the Stop Recording button:
6. To see what kind of  VBA generated  Point to Macro on the Tools menu, and then click Visual Basic Editor.
7. Click On Module Tree Node, From Expanding Double Click On Macro Name That You Gave