Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
I need something that will find the next number higher than i, whether it's i + 1 or i + 2 or i +7, etc.
Set top = Incidents.Columns("D:D").Find(What:=i, After:=[D4], LookIn:=xlValues) Set btm = Incidents.Columns("D:D").Find(What:=i + 1, After:=[D4], LookIn:=xlValues).Offset(-1, 0)
Join the community of 500,000 technology professionals and ask your questions.