Help with Function to Find the Next Row in a Column with Specific Criteria [Excel 2007]

Hello everyone,

I am having an issue with a function I have made in Excel 2007 and could use some assistance.

This function needs to be able to scan a column, either above or below the cell it's active in, to find the next closest cell with data in it. Furthermore, it needs to be able to exclude some data or text in certain cases, as well as search of for specific data or text. It should return the row number of the desired cell, not the contents.

I have attached a sample sheet which shows a few different cases and the desired output of a few examples. Attachment 374065

Below is my function, which works perfectly when I test it by calling it with a macro, it gives me an error (#VALUE) when I try to run it from the sheet. The issue appears to be related to the address/range input.

Please Login or Register  to view this content.

Thank you. I will look at your suggestion and give it a try. Not sure why the End If didn't post? I was trying to clean up the formatting a bit before posting here. I may have hit backspace one too many times.

That was it! Thank you so much for the help. I've found it's often small oversights that cause the issue...

Here's the full code, working as it should, if anyone would like it.

Please Login or Register  to view this content.

Thanks again.