for-next

  1. A

    Problem with For Loop: Trying to get data from multiple worksheets with certain name format dropped in table rows on a separate sheet

    <tbody> I have created the code below to grab specific data from multiple sheets within the workbook, and placing them in rows on a summary sheet. It either populates nothing or populates every row over and over again. It needs to occur automatically. <code>Sub Summary() Dim WkSht as...
  2. lopiteaux

    For-Next loop closing point not updating...

    Hi all, I have written a bit of code that cycles through tabled data and matches certain records with other records in the table. I start from the top using a For-Next loop and for every n in the first For-Next loop I run another loop on the same table in order to find the matching entry...
  3. L

    Basic Question - Excel Macro how to Define Range in For, Next

    I have some code that I run and a part of it says: Do While OX > 0 For g = 08, 11, 14, 17, 20 . . . Next g So I'm getting an error at the "For g" row because I'm sure I have the construction wrong. So how can I define this range so that it steps through (first g = 8, then at the "next g" it...

Some videos you may like

This Week's Hot Topics

Top