<div>
Does the cell consist only of the word &quot;find_me&quot;, or does it just contain the word, like &quot;can you find_me in this cell&quot;. &nbsp;Are you worried about upper or lower case?
</div>


Does the cell consist only of the word "find_me", or does it just contain the word, like "can you find_me in this cell".  Are you worried about upper or lower case?

<div>
<br />
activesheet.range(&quot;A:A&quot;).f<wbr />ind(&quot;find_<wbr />me&quot;).row
</div>



activesheet.range("A:A").find("find_me").row

<div>
A simple solution<br />
<br />

<pre><code id="code-8204667">Dim foundRow As Long

    Cells.Find(&quot;find_me&quot;, Range(&quot;A1&quot;), , xlByColumns).Activate

    foundRow = ActiveCell.Row

    MsgBox foundRow</code></pre>
</div>


A simple solution



Dim foundRow As Long

    Cells.Find("find_me", Range("A1"), , xlByColumns).Activate

    foundRow = ActiveCell.Row

    MsgBox foundRow

<div>
Although ssagibh's solution is simpler and better. &nbsp;I always forget the really easy methods!
</div>


Although ssagibh's solution is simpler and better.  I always forget the really easy methods!

<div>
Yes, the word find_me is case sensitive and only of the word &quot;find_me&quot;
</div>


Yes, the word find_me is case sensitive and only of the word "find_me"

<div>
how to show the row number &nbsp;which has exactly the value &quot;find_me&quot;?<br />
ssagibh's solution shows the row number of &quot;find_me_too&quot; &nbsp;which occurs before &quot;find_me&quot;
</div>


how to show the row number  which has exactly the value "find_me"?
ssagibh's solution shows the row number of "find_me_too"  which occurs before "find_me"

<div>
activesheet.range(&quot;A:A&quot;).f<wbr />ind(&quot;find_<wbr />me&quot;,,,xlwh<wbr />ole).row
</div>


activesheet.range("A:A").find("find_me",,,xlwhole).row

<div>
<div class="content wysiwyg-content">
HI<br />
I want to assign an variable &nbsp;in excel marco which returns &nbsp;the row number of a cell in Colume A with the word &quot;find_me&quot;. &nbsp;The word &quot;find_me only exist one time in column A. <br />
How can I do it?<br />
<br />
Thanks<br />
Peter<br />

</div>
</div>


HI
I want to assign an variable  in excel marco which returns  the row number of a cell in Colume A with the word "find_me".  The word "find_me only exist one time in column A. 
How can I do it?

Thanks
Peter


marcro to assign a variable to the row number of a cell contains a particular word

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