Home > Store

Looping, Downloadable Version

Register your product to gain access to bonus material or receive a coupon.

Looping, Downloadable Version

Downloadable Video

  • Sorry, this book is no longer in print.
  • About this video
  • Accessible from your Account page after purchase. Requires the free QuickTime Player software.

    Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.

Not for Sale

Audio & Video

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Description

  • Copyright 2010
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-7897-4537-2
  • ISBN-13: 978-0-7897-4537-8

Writing code is a way to automate a redundant task. Looping is a way to run your code over and over and over again. You can repeat the code for every worksheet in the workbook, every product in the catalog, every city in the country, or even every row in the worksheet - and that is 1.1 million rows now! With a loop, write the code once and have Excel run the code over and over. This is where the power of VBA really shines through. In these lessons you're going to learn about the basic For Next Loop as well as some other basic loops from Pascal. You will also learn about the new object-oriented loop call For Each.

Updates

Submit Errata

More Information

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.