Q-28142220.xls

<div>
<div class="content wysiwyg-content">
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?<br />
<br />
This would more than likely be a non-contiguous range. &nbsp;Is this possible? &nbsp;If so, how?<br />
<br />
Let's say I wanted to find all cells in a range with the text &quot;Joe&quot; in them and then get a range of ONLY those cells that had that text in them. &nbsp;What would the code look like for this?
</div>
</div>


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?

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?

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.