course excel in london

course excel in london - VB

Resolved · Low Priority · Version Standard

Rachel has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Rachel [3 posts] (2007 Oct 12 Fri, 17:01) Reply

how do you take out a particular function in a macro using the editor if you have made a mistake

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu	Bayswater	3	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	3	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
2007	2008 Dec 16 Tue	Bayswater	6	book now	£207	£215
Full Schedule: See all 109 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: VB

by - trainer Carlos gold contributer [479 posts] (2007 Oct 19 Fri, 16:41) Reply

Hi Rachel

Could yuo be more specific?

Have you made an error while recording the macro? ie deleted the wrong thing?

Carlos

RE: VB

by - delegate Rachel [3 posts] (2007 Oct 19 Fri, 16:46) Reply

Hi,
I have made an error when recording a macro and want to remove the line without having to delete the macro and re-record it.
thanks

RE: VB

by - trainer Carlos gold contributer [479 posts] (2007 Oct 24 Wed, 10:41) Reply

Rachel

In that case do the following:

1. Select the Tools menu

2. Click Macro / Macros (Alt + F8)

In th Macros dialog box

3. Select the macro you want to edit and click the Edit button

The Code window appears displaying your macro's code.

4. Edit/Delete the unwanted code

5. Close the code window and rerun the macro

Hope this helps

Carlos