Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Use the AutoFill function by specifying the destination range

Sub autoFillRange()     Cells(2, "B").autoFill Destination:=Range("B2:B10") End Sub