Macros

Hi Diana

Sorry if you got a bit lost with the Macro part of the course. It might help to use a simpler example of a macro than the one we used.

Suppose you want a macro to display your company name and address all in one cell. Start by placing your cursor in any blank cell. Then start recording as follows:

View, Macros, Record Macro
Type a macro name such as Company
Choose a shortcurt key eg C (Shift + C)
Click OK

Without clicking type your company name
Press Alt+Enter to wrap to a second line
Type your comany address pressing Alt+Enter for each new line.
When finished the address rather than pressing enter click the tick in the formula bar.

Now stop recording by clicking the small blue square at the bottom of the screen.

Your macro is now recorded! To run it click in a blank cell and press Ctrl+Shift+C

You can download the the Excel Advanced 2010 Reference from our website by logging in as a Delegate with your email address and passcode. It will show you how to assign a macro to a button and where best to store a macro. For example the company macro could be stored in the Personal macro woorkbook so it can be run from any workbook.

Hope this helps for now Diana. We also run a 2 day course on macros called Excel VBA Intro/Intermediate for writing macros to create and format Excel reports.

Regards
Doug

Doug Dunn
Best STL