Application.FlashFill Property (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

TRUE indicates that the Excel Flash Fill feature has been enabled and active. Boolean Read/Write

expression .FlashFill

expression A variable that represents a Application object.

Flash Fill detects when you are modifying data that fits a pattern which can be filled down and applied to additional data in the workbook, and then automatically fills down the column with the results.