Learn Excel 2010 - "Count Red Rows": Podcast #1687

Looking back to August 2011, a 'Learn Excel from MrExcel' Podcasts looked at how to Sum Colored Cells; Episode #1415 showed us how we could be obtaining the 'Sum' of the Red Rows. Today, in Episode #1687, Bill revisits that earlier Podcast to show us how to Count the Number of Rows containing Red Cells, not Sum the Cell Values. For help adapting the code in this video to other situations (such as also making sure the cell contains "dog"), start a new topic at http://www.mrexcel.com/forum/excel-questions/ "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! http://www.mrexcel.com/learn2010/LE2010.html And for more on VBA in Excel 2010, check out the book, "VBA And Macros: Microsoft Excel 2010", from Bill Jelen a.k.a. MrExcel. http://www.mrexcel.com/2010Books/vbamac2010.html "The Learn Excel from MrExcel Podcast Series" www.MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!