Bold active - unBold previous active

[werevollf]

Hello Excel Gurus,

Can someone help me out. I need code that based on active cell makes entire column and row Bold and then unBold them when different cell is selected and Bold the new column and row.
Hope it makes sense

I had no luck finding info on my matter..
I`m sorry if this a duplicate thread..

Thank you

 

[MPW]

This will do what you want, but be careful with the SelectionChange event. It can slow stuff down alot.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Cells.Font.Bold = False
    Rows(ActiveCell.Row).Font.Bold = True
    Columns(ActiveCell.Column).Font.Bold = True

End Sub

I also have it "unbold" all the other cells so you might have to modify it to leave some cells alone.

 

[MPW]

I should have mentioned that this goes on the worksheet, not in a module. Make sense?

 

[werevollf]

Thanks MPW, this worked like a charm