Highlight entire row when cell selected or being edited

[dim4x4]

Hello!

I want to have an entire row highlighted when I select or edit a cell in that row. Then when I select or edit a cell in a different row, I want initial row "unhighlighted" (i.e. returned to previous state), and the new row highlighted. Basically, I want to see which row I am working on right now.

Thank you!

 

[dim4x4]

Thank you very much, Fluff!!! ?

 

[Fluff]

Glad to help & thanks for the feedback.

 

[dim4x4]

Hi, Fluff! Sorry for bugging you again. One more thing. I noticed that when this code

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Me.Calculate
End Sub

is running, paste action (Ctrl+V) does not work. When I disable that code, paste functionality returns. What might be the cause? Thank you!

 

[Fluff]

That's because when the event code is triggered you loose the undo stack.

 

[dim4x4]

That's because when the event code is triggered you loose the undo stack.

Got it. Thank you!

 

[Fluff]

You're welcome.