select entire row of current cell

[mattborn]

I need to add a line of code that will select the entire row of the currently selected cell in Excel.

Thanks!

 

[xlbo]

activecell.entirerow.select
should do the trick

Rgds, Geoff
[blue]Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?[/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[SQLBI]

Matt,

This code will select the entire row based on the active cell.

Rows(ActiveCell.Row).Select

Hope this helps.

Leigh Moore
LJM Analysis Ltd

http://www.ljm-analysis.co.uk

 

[beniez]

Matt

Rows(ActiveCell.Row & ":" & ActiveCell.Row).Select

HTH

Ben

 

[beniez]

... and mine was the least elegant solution

 

[mattborn]

Thanks everybody, all versions are appreciated!