Advertisement
gn4711

Excel show selected row

Sep 18th, 2014
269
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # paste in sheet file
  2. Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  3.     Cells.Interior.ColorIndex = xlColorIndexNone
  4.     ActiveCell.EntireRow.Interior.ColorIndex = 34
  5. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement