Macros

The UK's most regular instructor-led training courses.
Training information: microsoft excel training courses · Microsoft+excel+training · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

1 post

ReplyWed 17 Jun 2009, 16:05Delegate Bhavesh said...

Bhavesh has attended:
Excel Advanced course

Macros

How do i record a macro?

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Wed 24 Mar 2010	Limehouse	7		£212	£217
2007	Fri 26 Mar 2010	Rochester (Hoo)	0	FULL
2007	Mon 29 Mar 2010	Bloomsbury	1		£235	£240
2003	Wed 31 Mar 2010	Southwark	7		£219	£224
2007	Tue 6 Apr 2010	Limehouse	5		£235	£240
2007	Fri 9 Apr 2010	Southwark	8		£193	£198
Full Schedule: See all 69 Excel Advanced course dates. Bookings currently available until 22nd December 2010.

649 posts

ReplyThu 18 Jun 2009, 14:03Trainer Simon said...

RE: Macros

Hi Bhavesh,

Thank you for your question and welcome to the forum.

To record a macro go to Tools, Macro and then Record a new macro.

Name the macro remembering not to use spaces(underscore between words is fine or no space) and then choose the location to save the macro.

Then click OK and then go through the procedure you want recorded. Then use the Stop recording button on the Stop recording toolbar.

I hope this answers your question.

Regards

Simon

Wed 24 Jun 2009: Automatically marked as resolved.

· Features of Microsoft Excel that assist in Analysis of Financial Data
· So what's new in Excel 2007?
· Advanced level training: Microsoft Excel and the Web
· Prepare for your MOS Certification with MS Excel Courses
· Microsoft Excel provides the building blocks of shared information

Please browse our web site to find out more about
microsoft excel training courses and other Microsoft training courses.

Excel tip:

Formula for last day of month

In some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1

View all Excel hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms and Conditions

Macros

Macros

RE: Macros

Related articles

Excel tip:

Formula for last day of month