In Excel VBA, Can I do a find on a range for all cells containing a value and have a range with just those cells found returned?
This would more than likely be a non-contiguous range. Is this possible? If so, how?
Let's say I wanted to find all cells in a range with the text "Joe" in them and then get a range of ONLY those cells that had that text in them. What would the code look like for this?