Performance becomes an issue with large datasets too. A poorly written macro can bog down Excel and take forever to complete, ...

How to Convert All Excel Sheets to CSV With Macros. Excel's Save As command lets you save a single worksheet in the CSV (comma seperated value) format, but not an entire workbook. Saving ...

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.

Unhiding Excel sheets is easy, but can be tedious. Use this simple macro to unhide all hidden sheets in an Excel workbook.

This tutorial will explain how to find a value in an Excel column using the Find function in VBA.

If you are new to macros, check out my dedicated guide below, where I go over the benefits and step-by-step instructions for creating macros in Excel.

Web-based spreadsheet Zoho Sheet yesterday unveiled macro recording and playback, bringing it one major step closer to matching Excel's most important features. As of April, Zoho Sheet could ...

The new user interface in the latest version of Microsoft Excel changes all the rules. Here's how to find your way around and get the most out of Excel 2007.

Want to complete ongoing PPC tasks more quickly? Here are some ways to use Excel Macros that can save you time and help ensure accuracy.