Fri, 24 February 2012
Bill looks at pasting Values today, in Episode #1521. Using one line of VBA code, Bill shows us how to convert Formulas to Values. Learn how to quickly - and Easily - modify your recorded macro [using the Macro Recorder] to Paste Values with one click.
...Today's Podcast topic may be found in Bill's book, "VBA and Macros: Microsoft Excel 2010" by Bill Jelen and Tracy Syrstad. The fastest, best way to go beyond the Macro Recorder and move up the Excel VBA learning curve...Includes crucial information on making Excel 2010 VBA code work with older versions.
“The Learn Excel from MrExcel Podcast Series”
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!