Fill formula according according Column c

hello
i m using below code to fill formula

Sub OF_BC_COPY_ALL_FORMULA()
    Range("F9:O9").Select
    Selection.AutoFill Destination:=Range("F9:O1500")
    Range("F9:O1500").Select
    Range("C9").Select
End Sub

but in above code i want little change

Range("F9:O9").Select

this code paste data only according column c

i mean if i have data till C160 then formula paste only

Selection.AutoFill Destination:=Range("F9:O160")

thanx a lot