Finding a range

Does anyone know if it is possible to find a range when the start of the range and the end of the range will always vary. I am trying to find a range of a specific set of data that is indicated by an expense number. This number is located in column A. I want the range to start when this expense number starts on the worksheet. I want the range to end once it finds a blank row.


I pasted an example, the range I am looking for would start at the row where 38D appears and ends where 38D ends.

I hope this makes sense, and thanks in advance for looking and any possible assistance.

This may be overkill, but I believe this post will lead you in the right direction:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.