The Idea Dude
Well-known Member
- Joined
- Aug 15, 2002
- Messages
- 591
- Office Version
- 2016
- Platform
- Windows
Hi,
I need to loop through a range but going from bottom to top. ie....
I need to loop through the cells in range I2:I48 but starting from row 48. If a cell has the value 8 in it then I need range L3 to equal the the cell 2 to the left of the cell that had 8 in it, then it needs to exit the sub.
Any assistance would be greatly appreciated.....thank you
I need to loop through a range but going from bottom to top. ie....
I need to loop through the cells in range I2:I48 but starting from row 48. If a cell has the value 8 in it then I need range L3 to equal the the cell 2 to the left of the cell that had 8 in it, then it needs to exit the sub.
Any assistance would be greatly appreciated.....thank you