sharky12345
Well-known Member
- Joined
- Aug 5, 2010
- Messages
- 3,421
- Office Version
- 2016
- Platform
- Windows
I'm using this to loop through a range of cells and grab their values for use later:
At the moment it starts at the bottom and works up, but I need it to do the reverse and start at the top - can someone show me how please?
Code:
For Each Cell In Sheet11.Range("J2:J20")If Cell.Value = "YES" Then
Links = Cell.Offset(0, -8).Value & " " & Cell.Offset(0, -7).Value & vbNewLine & Links
End If
Next
At the moment it starts at the bottom and works up, but I need it to do the reverse and start at the top - can someone show me how please?