Autofill a column but ignore Cells without formulas ?

[JumboCactuar]

Hi,
i have a column with formulas but sometimes manual entry is required to these cells.

I have a formula which restores the formulas in the column, but i want it to skip any cells with raw data

Range("N2").AutoFill Destination:=Range("N2:N2500"), Type:=xlFillDefault

Currently if for example N7 has a manual input of 100, this formula will write over it with the autofill

Reason for this is sometimes the formulas get broken and parts of it show as #REF , so maybe an aternative way to filter only broken formulas

Not sure if this is possible, appreciate any help

 

[Akuini]

Maybe this:

Range("N2").Copy
Range("N2:N2500").SpecialCells(xlCellTypeFormulas).PasteSpecial paste:=xlPasteFormulas