recorded this line in a macro....

Need for this to read as an open range instead of stopping at F784.
Will always start at A2- F2 but last row (F784) may change..


Selection.AutoFill Destination:=Range("A2:F784")

To find the last row based on F

iLastRow=Range("F65536").end(xlup).row
Then you substitute in your instruction:
Selection.AutoFill Destination:=Range("A2:F" & iLastRow)
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"J.W. Aldridge" wrote:

> recorded this line in a macro....
>
> Need for this to read as an open range instead of stopping at F784.
> Will always start at A2- F2 but last row (F784) may change..
>
>
> Selection.AutoFill Destination:=Range("A2:F784")
>