13. Macros and UDFs
You don’t need to be a programmer to record macros or create UDFs. This chapter will teach you how to get the most out of the macro recorder and how to create custom functions.
VBA macros enable you to automate any process in Excel. The macro recorder is provided to help create macros, but there are undocumented rules that must be followed to have the macro recorder work successfully. This chapter teaches you how to successfully record a simple macro that can deal with datasets of any size. It also introduces you to user-defined functions (UDF), which are useful when a built-in function doesn’t exist for your needs.
Get Using Microsoft® Excel® 2010 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.