dayton,

you could try the following:
Selection.AutoFill Destination:=Range(Range("I2"),Range("I65536").End (xlUp))

John

dayton wrote:

I use the following in my macro:
Selection.AutoFill Destination:=Range("I2:I111")

The problem I have is that the ending range (I111) worked great the first
time, but now my files are different sizes. Is there a EOF range I can use.
I need the range to always select the "end of file".

T.I.A.