Ask Learn
Preview
Please sign in to use this experience.
Sign inNote
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
You can clear styles that have been added to a NamedRange control or a native Excel range object by applying the Normal style to the range.
Applies to: The information in this topic applies to document-level projects and application-level projects for Excel 2007 and Excel 2010. For more information, see Features Available by Office Application and Project Type.
This example assumes that you have a NamedRange control named rangeStyles on the worksheet. The following code must be placed in a sheet class, not in the ThisWorkbook class.
Apply the Normal style to the range. This code must be placed in a sheet class, not in the ThisWorkbook class.
Me.rangeStyles.Style = "Normal"this.rangeStyles.Style = "Normal";
Apply the Normal style to the range.
Dim rng As Excel.Range = Me.Application.Range("A1") rng.Style = "Normal"Excel.Range rng = this.Application.get_Range("A1", missing); rng.Style = "Normal";