Excel.SpecialCellType enum
Remarks
Fields
| blanks = "Blanks" | Cells with no content. |
| conditionalFormats = "ConditionalFormats" | All cells with conditional formats. |
| constants = "Constants" | Cells containing constants. |
| dataValidations = "DataValidations" | Cells with validation criteria. |
| formulas = "Formulas" | Cells containing formulas. |
| sameConditionalFormat = "SameConditionalFormat" | Cells with the same conditional format as the first cell in the range. |
| sameDataValidation = "SameDataValidation" | Cells with the same data validation criteria as the first cell in the range. |
| visible = "Visible" | Cells that are visible. |
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
Office Add-ins
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for