[EXCEL] Select a row when clicking a cell

[LeBob]

Hi,

I drill down in the excel help and don't find my answer so, HELPPPP !!!
Is there anyone who knows how to select an entire row when you select one cell in it.
What I mean is when I select C4 cell I want (I hope) that excel automatically selects the row number 4 (as if I select this row by clicking its number).

Thanks.

 

[Anne Troy]

Select?
Or highlight?
If highlight, you can try something like this:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=145

If you want Select, let me know and I'll have an entry made.

 

[Rollin_Again]

Right click on the sheet name along the bottom of the workbook and select VIEW CODE and then paste the following code into the blank module window. Save the workbook and give it a try.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Rows(ActiveCell.Row).Select

End Sub

Rollin

 

[Anne Troy]

That was simple enuf, Rollin. Can I steal it?

 

[Zack Barresse]

If you don't want this to fire everytime, which Rollin's will do, the keyboard shortcut is Shift + Spacebar.

 

[LeBob]

Les gars vous êtes géniaux !!!
Folks you're great

Well a great thanks to everyone.
The simpliest (Shft Space) is the winner for my use but all your VB examples are welcomed.
Shame on me ! I have to learn VB right now, I promise !!!

Thanks again
Bob

 

[Zack Barresse]

Glad it worked out for ya Bob!

Btw, what does "Les gars vous êtes géniaux" mean?

Take care!

 

[LeBob]

I'm a frenchy that's why I said

Guys you are inspired / full of genius !

or

You're genius

but maybe the translation can't be so linear ?