Tag Archives: Remove

No Thumbnail

Excel VBA, Remove Fill Pattern

Jump To: Remove Fill Pattern From Cell Remove Fill Pattern From Range Remove Fill Pattern From Column Remove Fill Pattern From Row Remove All Fill Pattern From Sheet – Remove Fill Pattern From Cell: The following line of code removes the fill pattern from cell

No Thumbnail

Excel VBA Remove Sheet Fill Color

The following line of code removes any fill color applied to the cells in sheet 2: Sheet2.Cells.Interior.Color = xlNone Before: After: See also: Excel VBA, Cell Fill Color Excel VBA, Formatting Cells and Ranges using the Macro Recorder If you need assistance with your code, or you

No Thumbnail

Excel VBA Remove Row Fill Color

The following line of code removes the fill color of the first row: Rows(1).Interior.Color = xlNone  Before: After: See also: Excel VBA, Cell Fill Color Excel VBA, Formatting Cells and Ranges using the Macro Recorder If you need assistance with your code, or you are looking

No Thumbnail

Word VBA, Delete Equations

In order to delete an equation using VBA for word, you will have to know its index. Equations are referenced through the OMaths collection. In the example the below the first equation in the document is removed along with all its text: OMaths.Item(1).Range.Select Selection.Delete Before: After:

No Thumbnail

Word, Remove Fill in Rules

In order to remove the Fill in Rules in a document: Step 1: Press Alt + F9. Step 2: Look for FILLIN fields and remove them: See also: Word Ask Rule (Mail Merge) Microsoft Office Support, Field Codes: Ask Field If you need assistance with your code, or

No Thumbnail

Word VBA, Removing Picture Captions

In this article I will explain how you can remove caption from all the images in a document. As explained in the article Word VBA, Loop Through Images there are basically 2 types of images: Floating Inline The 2 image types have different types of caption and

No Thumbnail

Excel VBA, Remove Border

In this article I will explain how you can remove borders from a range of cells. Removing borders is similar to creating borders. All you have to do is set the .LineStyle property to xlNone. For more information about creating borders please see Excel VBA,

No Thumbnail

Word, Remove Ask Field

In order to remove the Ask Fields in a document: Step 1: Press Alt + F9. Step 2: Look for ASK and REF fields and remove them: See also: Word Ask Rule (Mail Merge) Microsoft Office Support, Field Codes: Ask Field If you need assistance with your code, or

No Thumbnail

Excel VBA Remove Column Fill Color

The following line of code removes the fill color of the first column: Columns(1).Interior.Color = xlNone  Before: After: See also: Excel VBA, Cell Fill Color Excel VBA, Formatting Cells and Ranges using the Macro Recorder If you need assistance with your code, or you are looking

No Thumbnail

Excel, Can’t Remove Cell Fill Color

If you have an Excel workbook with cells that have a fill color that can’t be removed, there are 2 possible reasons for this. – Reason #1, Conditional Formatting: Conditional formatting might have been applied to the cell or range. Conditional formatting will create a