Wednesday, 26 January 2011

VBA and Macros 2010 – Marking Duplicates: Podcast #1326

January 19, 2011

Conditional Formatting offers the ability to mark duplicates or uniques, but in some respects, it sort of missed the boat. Today, in Episode #1326, Bill looks at how to use a formula-based conditions with VBA to fill voids left by Condtional Formatting.

"VBA and Macros: Microsoft Excel 2010" by Bill Jelen and Tracy SyrstadFrom Chapter 15…This episode is the video podcast companion to the book, “VBA And Macros: Microsoft Excel 2010“, from Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Entry filed under: Excel 2007, Excel 2010, VBA and Macros. Tags: 2010, accounting, Bill Jelen, business, conditional formatting, Excel, Excel 2010, formula, Macro, Macro Recorder, MrExcel, spreadsheets, technology, tutorial, VBA, Worksheet.


View the original article here