Skip to content

Instantly share code, notes, and snippets.

@Miopas

Miopas/excel.script

Created May 9, 2018 11:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Miopas/bb2a27754d1cc6bb5b3cf4e45ab39f50 to your computer and use it in GitHub Desktop.
Save Miopas/bb2a27754d1cc6bb5b3cf4e45ab39f50 to your computer and use it in GitHub Desktop.
Download ZIP
Excel 高亮行
Raw
excel.script
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
Rows(Target.row).Interior.ColorIndex = 36 '所在行高亮显示
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment