• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Using Loops

It often happens in VBA code—particularly code that is intended to add, edit, copy, move, or delete data values—that you want to make reference to many values or cells or rows, one at a time. You might want to add recently obtained records to a set that already exists, or to edit many values by concatenating onto each a string such as @mydomain.com, or to add new records to a database table and assign them values from your worksheet.

By designing loops correctly, you can carry out actions a huge number of times and get your results with great speed and accuracy.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint