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 2007
Sally has attended:
Excel Intermediate course
Macros
Can you create a macro for all functions you may use?
RE: Macros - Functions!!
Dear Sally
Thank you for attending Excel 2007 Intermediate/Advanced course!! I hope you enjoyed the course and benefited from it.
Macro can be created NOT ONLY for Functions BUT ANY group of tasks that you repeatedly perform!! For example if you find yourself changing the formatting of certain cells to currency with zero decimal places and any negative numbers in red, Bold and center justified. All these actions can be recorded as one macro command and can be performed with a click of a button if you assign the macro to a button on the Quick Access Toolbar!!
Coming to your original question Yes any function can be recorded as a macro. This is particularly helpful if the spreadsheet is going to be used y someone who has no understanding of formulae/functions!! Or if that function is very complicated and needs to be entered in various location in the same worksheet or different worksheet. Please always remember to press the relative button so the cells change accordingly when the macro is applied to different cells
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
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:Switching Between SpreadsheetsAs the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet. |