how to insert code?

How do i insert such a code into excel for it to work?

Please Login or Register  to view this content.

[/QUOTE]

Hello charmaine88,

Installing the Macro

1. Copy the macro using the CTRL+C keys.
2. Open the Excel workbook the macro will run in.
3. Open the Visual Basic Editor (VBE) using the keys ALT+F11.
4. Activate the Insert Menu with the keys ALT+I.
5. Insert a new module for the macro by pressing the key M.
6. Paste the macro into the module using the keys CTRL+V.
7. Make any custom changes to the code at this time!
8. Save the macro using the keys CTRL+S.
9. Exit the VBE and return to Excel using ALT+Q.

Sincerely,
Leith Ross