<div>
<div class="content wysiwyg-content">
How can I &nbsp;(with VBA not formula) return the column letter where a certain string is found in row 1?<br />
<br />
So for example column letter where the string &quot;Specialized&quot; is found in row 1?<br />
<br />
A string appears only once.<br />
<br />
thanks.
</div>
</div>


How can I  (with VBA not formula) return the column letter where a certain string is found in row 1?

So for example column letter where the string "Specialized" is found in row 1?

A string appears only once.

thanks.

Excel VBA to display column letter of a certain string

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.