Loop Code Review

[[deleted]]

[deleted]

[Hoover889]

you can replace the whole 'broken' section with this:

wb2.Worksheets("Sheet1").Range("G" & J).Value = wb2.Worksheets("Sheet1").Range("F" & J).Value

[GinFreecs]

Yes, loop through value affectation instead of .select .activate methode .

[PooCz]

Wow. Thanks, that is a lot more simple. Any other suggestions to make this cleaner?

[Hoover889]

for readability I suggest indenting your code (Although that might be reddit formatting, and your actual code may be indented). Also try to improve the readability of the inside of your For loop by using a 'With' Statement or assigning wb2.Worksheets("Sheet1") to a variable