I'd like to cycle through a range testing values on a sheet without activating it - the main reason being the trigger event is when a tab is activated, and if I have to reactivate it I get into an infinite loop. So I'm trying to figure out something like this, the asterisk line being where I'm hanging up. Hopefully you get the idea
oop = Sheets("Pricing Defs").Range("c23").Value
r = Sheets("Pricing Defs").Range("c16").Value
x = Sheets("Deductible Factors 2017").Range("l5").Value
i = 0
Do Until x > oop
i = 1 + i
x = Sheets("Deductible Factors 2017").Range("l5").Offset(i, 0).Value*****
Loop
Bookmarks