I have the following macro below. I have protecteed cells in Col H and only wanted the formula inserted in those sells that are unprotected
Code:
Sub Net_Totals()
Finalrow = Range("A65536").End(xlUp).Row - 4
Range("H8:H" & Finalrow).FormulaR1C1 = "=RC[-2]-RC[-1]"
End Sub