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.