For each next loop only retuns 1st value?

**maym** · 07-02-2017, 07:26 PM

Hi

I have a for each loop in my macro that copies data from sheet 1 to sheet 2. It works for the first part, but then when I call it again, it only returns the first value. Can anyone help me with this problem? Code is:

Please Login or Register  to view this content.

**leelnich** · 07-02-2017, 07:37 PM

On the problem line:

Please Login or Register  to view this content.

For values of i less than 5, this offset would point to non-existent rows. I assume it doesn't happen (because said values don't test TRUE), or we'd be talking about errors..

**maym** · 07-02-2017, 07:40 PM

thanks but this is the same as the first routine in the macro which works so I don't quite understand why it would not work?

For each next loop only retuns 1st value?

LinkBack

Thread Tools

Rate This Thread

Display

For each next loop only retuns 1st value?

Re: For each next loop only retuns 1st value?

Re: For each next loop only retuns 1st value?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] (Beginner help) For loop inside do loop that displays information from reference sheet.

[SOLVED] Auto email loop with formatted table data breaking on second loop VBA

[SOLVED] VBA to loop within a loop of multiple blocks of data (currentregion) ... Expert needed

Loop through multiple files and call macros (but unable to loop)

[SOLVED] Copy dynamically changing column and Paste using VBA Loop (Loop within Loop)

Why did an inner loop variable start overwriting the outer loop range suddenly?

Loop a column on Sheet1 and loop a row on Sheet2 to find a match

Bookmarks

Bookmarks

Posting Permissions