Скачать или смотреть Highlight Active Row and Column in Excel | SIMPLE TRICK to Highlight Row and Column using VBA

Highlight Active Row and Column in Excel | SIMPLE TRICK to Highlight Row and Column using VBA

Highlight Active Row and Column in Excel,
SIMPLE TRICK to Highlight Row and Column using VBA,
highlight active row and column using VBA,
highlight current row and column in excel,
#HighlightActiveRowAndColumn
excel conditional formatting,
conditional formatting,
from bshadkumar,
highlight active row in excel,
highlight active columnn in excel,
highlight active row and column,
highlight the active row and column in excel,
color the row and column,
_______________________________
procedure
right click sheetname - view code -change general to worksheet - paste this code


copysheetname = ActiveSheet.Name
Worksheets(copysheetname).Cells.Interior.ColorIndex = xlNone
Dim a As Integer
Dim b As Integer
a = ActiveCell.Row
b = ActiveCell.Column
Worksheets(copysheetname).Rows(a).Interior.ColorIndex = 4
Worksheets(copysheetname).Columns(b).Interior.ColorIndex = 4
Worksheets(copysheetname).Cells(a, b).Interior.ColorIndex = 4