Learn Excel 2010 – “Select An Entire Table with VBA”: Podcast #1656

February 28, 2013 at 2:49 pm


The Macro Recorder often returns Code that works today…but may not work every day. Although Pete sent in a question about using a Loop, Bill had to comment on Code designed to select an entire Table. With a few quick changes, Bill’s new Code shortens 7 lines of the Recorded Code into 1 line – but it will only work if the ‘Shape’ of the Data is matches the imagine that Bill has in his head. Today, in Episode #1656, Bill presents: ‘A Long Story About What Can Go Wrong with Recorded Code’.

"VBA and Macros: Excel 2010" by Bill Jelen and Tracy Syrstad…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!

Advertisements

Entry filed under: Bill Jelen, Excel 2010, Excel Everywhere, Excel for Students, Excel For Teachers, Learn Excel 2007 through Excel 2010, Learn Excel 2010, Learn Excel from MrExcel, Microsoft Excel, Microsoft Excel 2010, MrExcel, MrExcel Podcast, MrExcel Products, New MrExcel Publication, QUE Publishing and BIll Jelen. Tags: , , , , , , , , , , , , , , , , , , , , , , , .

Learn Excel 2013 – “Subtract in a Pivot Table”: Podcast #1655 Dueling Excel – “Get Averages for a Set of Numbers”: Podcast #1657


Learn Excel from MrExcel

Learn Excel Podcast Splash Screen

The Excel Beginners Book:

"Don't Fear The Spreadsheet" - by Tyler Nash, Bill Jelen, Tom Urtis and Kevin Jones

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 738 other followers

Live Lessons Excel 2010 DVD

"Live Lessons Excel 2010" DVD

RSS MrExcel Recent Articles

  • An error has occurred; the feed is probably down. Try again later.

Recent MrExcel Tweets

MrExcel Podcast Archive


%d bloggers like this: