98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Macros
Macros
Resolved · Low Priority · Version Standard
RE: macros
Dear Fern
Thank you for attending the Excel Advanced Course. I hope you enjoyed it.
You can access the Visual Basic Editor to make necessary changes for your current macro. Please bear in mind that this window expects you to have knowledge of VBA (Visual basic For Application) which is a programming language. You can do simple changes such as changing the name, changing the margins, or calculations in a formula quite simply but if you want to do more complicated editing then I would suggest you to attend our two day course to get in-depth knowledge and understanding of creating/editing macros.
Below is an example how you
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:Selecting constant values onlyIf periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter. |