macros- recording and coding

 Macros - is excel technology where we can update big data, calculation, set formula etc  within time with accuracy.

We need to understand what you need to work as per requirement.

You can work by coding and macros recording.

Macros recording - 

1. On view tab, in the macros group, click on macros command.

2. Click on record macros

 3. In the record macros dialog box:b

1. Enter a macros name. Choose a name that clearly identifies the macro. You may not use spaces.
2. Enter a macros name. You will be able to run the macro using this shortcut key.
3. Choose where to store the macro. You will normally accept the default.
4. Enter a description. Briefly explain what the macro does.

4. Click on ok

After clicking ok, every keystroke us recorded

5. To stop recording and view macros tab

Coding- 1 create macros- With Excel VBA you can automate tasks in Excel by writing so called macros. In this chapter, learn how to create a simple macro.

2. The MsgBox is a dialog box in Excel VBA you can use to inform the users of your program.

3. Work book and worksheet-Learn more about the Workbook and Worksheet object in Excel VBA.

The Range object, which is the representation of a 4. cell (or cells) on your worksheet, is the most important object of excel VBA.

5. Looping is one of the most powerful programming techniques. A loop in Excel VBA enables you to loop through a range of cells with just a few codes lines.

1. Open Visual basic editor

2. Click on insert , module 

3. Create procedure (macros called cyan)

4. The Sub changes background colore to worksheet on cyan

Call.interior.coloreindex=28