Yesterday in Episode #1690, Bill looked at Totaling up hours in a schedule; originally, he wanted to show the formulas for that Podcast to the right of the work applied. Today, in Episode #1691, Bill tells us how the =FORMULATEXT Function in Excel 2013 works and then shows us how to create that same functionality for Excel 2010!

Another simple ‘Beginner Project’ for the aspiring Excel User looking to try a little VBA. Follow along, give it a try and see how you may apply the use of this simple Macro as you create and use your first Visual Basic for Applications Project in Excel 2010!


“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!

and for more on VBA in Excel 2010,

"VBA and Macros: Microsoft Excel 2010" by Bill Jelen and Tracy Syrstadcheck out the book, “VBA And Macros: Microsoft Excel 2010“, from Bill Jelen a.k.a. MrExcel.

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

“The Learn Excel from MrExcel Podcast Series”