I got a great function from zorvek last week that does just that through use of an array. But the array causes me some problems elsewhere in the workbook. So I think I really need a macro to do this.
I've been working on it for more time than I want to admit, and i Just can't firgure it out. Please take a look at this workbook and correct my code if it's salvagable, or give me another direction if it's not.
Right now I just want to be able to parse the cells with only one range defined in them. Then we'll move on to the more complicated part.