Hi,
I have this code that fills down formulas to a certain column.
But the issue is if the value is 0 then the cell will show #DIV/0!
How can I adjust the code so that it will show a blanck cell?
I have tried entering the formula as iferror as well but that won't workDim Lastrow As Long Lastrow = .Range("A" & .Rows.Count).End(xlUp).Row Set ws1 = ThisWorkbook.Sheets("Sheet1") With ws1 .Range("F7:F" & Lastrow).Formula = "=(H7-G7)/G7" End with
Any assistance is greatly appreciated
Bookmarks