i need a bit of help to insert a formula into a worksheet by the use of vba, when i try to do it i get an error, here ie the bit of code i am trying with
Range("aa6").formulaR1C1 = "=IF(E6="agy","",IF(E6="o/t","",IF(COUNT(F6,G6)=2,(H6-F6+(H6<F6))*24-0.75,"")))" Range("aa6:ac250").FillDown
I get the error on the red text, i get a message box saying compile error,expected end of statment
Thank you for any help
Ian