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

Excel macros may be confusing at first glance, but they're easy to create and can save you a lot of time ...

If you have simple tasks that you need to perform in Excel often, you can actually “teach” Excel to do them for you by recording a macro.

Q: I have written an Excel macro that copies a column of data on Sheet1 and pastes that data as a row on Sheet2. However, I want the paste location to drop down to the next blank row each time I paste ...

No reason to feel intimidated by macros again. In this post you'll learn how to apply macros in six easy steps!

Excel 4.0 macros are “something incredibly old, but nothing incredibly fancy,” said Ortolani. It takes a user about 30 seconds to create a simple macro that can display a message on the screen ...

Excel VBA allows you to call an external function or module with a simple "=NameOfFunctionToCall" entry in the code syntax. However, in .NET applications, you should always use the "Call ...

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

When it comes to executing actions and performing tasks, faster is always better. Learn two tricks that will make your Excel macros more efficient.

Another concern I voiced was the difficulty involved in writing AppleScripts for Office 2008 versus the ease of creating simple macros in Word and Excel using today’s Record Macro menu item.