Share via

FillFormat.Solid Method

  • Article
Excel Developer Reference

Sets the specified fill to a uniform color. Use this method to convert a gradient, textured, patterned, or background fill back to a solid fill.

Syntax

expression.Solid

expression   A variable that represents a FillFormat object.

Example

This example converts all fills on myDocument to uniform red fills.

Visual Basic for Applications 
  Set myDocument = Worksheets(1)
For Each s In myDocument.Shapes
    With s.Fill
        .Solid
        .ForeColor.RGB = RGB(255, 0, 0)
    End With
Next

See Also