98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » course excel in london - VB
course excel in london - VB
Resolved · Low Priority · Version Standard
Fri 12 Oct 2007, 17:01Delegate Rachel said...
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
Fri 19 Oct 2007, 16:41Trainer Carlos said...
RE: VB
Hi Rachel
Could yuo be more specific?
Have you made an error while recording the macro? ie deleted the wrong thing?
Carlos
Fri 19 Oct 2007, 16:46Delegate Rachel said...
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
Wed 24 Oct 2007, 10:41Trainer Carlos said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Converting an American date format to European using FormulaExcel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following. |
