<div>
Try this...<br />
<br />

<pre><code id="code-20-40740602-1">Range(&quot;A9&quot;).EntireRow.Find(What:=&quot;*Market*&quot;, After:=cells(1,9) LookIn:=xlFormulas, LookAt:=xlWhole) </code></pre>
<br />
Saurabh...
</div>


Try this...



Range("A9").EntireRow.Find(What:="*Market*", After:=cells(1,9) LookIn:=xlFormulas, LookAt:=xlWhole) 


Saurabh...

<div>
It's not actually a good idea to search entire rows and columns so maybe<br />
<br />

<pre><code id="code-20-40740648-1">Range(&quot;A9&quot;).EntireRow.SpecialCells(xlCellTypeConstants).Find(What:=&quot;*Market*&quot;, After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlWhole).Select</code></pre>
<br />
What error are you getting?
</div>


It's not actually a good idea to search entire rows and columns so maybe



Range("A9").EntireRow.SpecialCells(xlCellTypeConstants).Find(What:="*Market*", After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlWhole).Select


What error are you getting?

<div>
What error are you getting?<br />
<br />
Where's the rest of the code?
</div>


What error are you getting?

Where's the rest of the code?

<div>
The code on its own will cause a compile error, that's why I'm asking where the rest if the code is.
</div>


The code on its own will cause a compile error, that's why I'm asking where the rest if the code is.

<div>
I'm glad I was able to help.<br />
<br />
In <a href="https://www.experts-exchange.com/M_258447.html" rel="ugc">my profile</a> you'll find links to some articles I've written that may interest you.<br />
Marty - MVP 2009 to 2015
</div>


I'm glad I was able to help.

In my profile [https://www.experts-exchange.com/M_258447.html] you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015

<div>
Already checked them out, very helpful articles. Thanks
</div>


Already checked them out, very helpful articles. Thanks

<div>
<div class="content wysiwyg-content">
I am using this code but I am getting an error. Any idea why?<br />
<br />
Range(&quot;A9&quot;).EntireRow.Find<wbr />(What:=&quot;*M<wbr />arket*&quot;, After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlWhole)
</div>
</div>


I am using this code but I am getting an error. Any idea why?

Range("A9").EntireRow.Find(What:="*Market*", After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlWhole)

In VBA why can't I search the entire row belonging to a specific cell?

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

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.