Excel macros save you time and headaches by automating repetitive tasks, and you don’t have to be a programmer to write one. Use these tips to make macro recording a cinch.

An Excel macro is a sequence of commands (or directives) that you record to perform a series of tasks. We'll show you how to create custom macros for your spreadsheet.

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of your ...

Microsoft Excel offers two ways to link sheets in a workbook: hyperlinks and macros. Hyperlinks use the program's ribbon controls, while macros use Visual Basic code.

After creating UserForm1 for one Excel application, you realize that you'll want to use it again -- with a few modifications -- in another application. You do not need to recreate the form; simply ...