Rachel has attended:
Excel Intermediate course
Excel Advanced course
Excel Intermediate course
VB
how do you take out a particular function in a macro using the editor if you have made a mistake
RE: VB
Hi Rachel
Could yuo be more specific?
Have you made an error while recording the macro? ie deleted the wrong thing?
Carlos
RE: VB
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
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
