for counter = 200 to 1 Step -1
if cells(200-counter, 1) = "blah") then...
end if
next counter


"J@Y" wrote in message
...
Is there an efficient way to searching from the bottom of a range up?

I have this:

for counter = 1 to 200
if cells(200-counter, 1) = "blah") then...
endif
next counter