Return to site

You tube auto-highlight row and column of active cell in excel for mac?

broken image

The following code example clears the color in all the cells on the worksheet by setting the ColorIndex property equal to 0, and then highlights the active cell by setting the ColorIndex property equal to 8 (Turquoise). Sample code provided by: Tom Urtis, Atlas Programming Management Highlighting the Active Cell These examples use the SelectionChange event of the Worksheet object.

broken image
broken image
broken image

The following code examples show ways to highlight the active cell or the rows and columns that contain the active cell.