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