Highlight correspondence row

[sambit]

Hi,
pl help If I select any cell in a table, correspondence row should be highlight.

 

[Khalid NGO]

Hi Sambit,
I think you should go through this:
http://chandoo.org/wp/2012/07/11/highlight-row-column-of-selected-cell-using-vba/

Regards,

 

[sambit]

Hi Khalid,
Thanks for reply. but when I select range of cell getting

Run time error '424':
object required.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
[selrow] = Target.Row
[selcol] = Target.Column
End Sub

 

[Khalid NGO]

You have to mentioned selrow & selcol to perform VBA+CF as Chandoo did in his sample file.
I suggest you to download the sample file, and then manage your work accordingly.

 

[Hui]

See attached:

 

[sambit]

Hui Sir,
Thank you very much.