How to: Programmatically Change Formatting in Worksheet Rows Containing Selected Cells
You can change the font of an entire row that contains a selected cell so that the text is bold.
Applies to: The information in this topic applies to document-level projects and VSTO add-in projects for Excel. For more information, see Features Available by Office Application and Project Type.
To make the current row bold and the previously bolded row normal
Declare a static variable to keep track of the previously selected row.
Retrieve a reference to the current cell using the ActiveCell property.
Style the current row bold using the EntireRow property of the active cell.
Ensure that the current value of
previousRowis not 0. A 0 (zero) indicates that this is the first time through this code.Ensure that the current row is different from the previous row.
Retrieve a reference to a range that represents the row that was previously selected, and set that row to not be bold.
Store the current row so that it can become the previous row on the next pass.
The following example shows the complete method.
Working with Worksheets
How to: Programmatically Apply Styles to Ranges in Workbooks
How to: Programmatically Copy Data and Formatting across Worksheets
Optional Parameters in Office Solutions