<div>
If you have selected the cell it is simply<br />
<br />
<br />
ActiveCell.Row<br />
<br />
eg<br />
<br />
MsgBox &quot;The row is &quot;&nbsp;&amp; ActiveCell.Row
</div>


If you have selected the cell it is simply


ActiveCell.Row

eg

MsgBox "The row is " & ActiveCell.Row

<div>
and if you want to go on and select that row<br />
<br />
Dim x As Long<br />
x = ActiveCell.Row<br />
<br />
Rows(x).Select
</div>


and if you want to go on and select that row

Dim x As Long
x = ActiveCell.Row

Rows(x).Select

<div>
or<br />
activecell.entirerow.copy
</div>


<div>
<div class="content wysiwyg-content">
Is the a piece of code that will enable me to select the entire row and copy that row from the cell I have landed on. i.e. My macro looks for a specific word, when it finds the word it selects the cell. Lets say I am on cell P32, can I then select the entire row 32?<br />
<br />
I am using 2010<br />
<br />
Thank you
</div>
</div>


Is the a piece of code that will enable me to select the entire row and copy that row from the cell I have landed on. i.e. My macro looks for a specific word, when it finds the word it selects the cell. Lets say I am on cell P32, can I then select the entire row 32?

I am using 2010

Thank you

Select entire row from any cell

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.

Microsoft Office

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

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