AutoFill in Excel VBA Code

AutoFill in Excel VBA Code

AutoFill:

To fill cells with data that follows a pattern or are based on data in other cells.

Let’s do some coding around to do the same:

Sub AutoFill()
    Range("A2").AutoFill Destination:=Range("C2:A26"), Type:=xlFillDefault
End Sub

The above code will apply on below source:

Post code execution the output will look like as follow and perform AutoFill:

Please leave your valuable comments

Leave a Reply

Your email address will not be published.