Hi, I am trying to add VBA for inserting formula in a range, but compile error is coming. Can someone please help on this. i have imported the macro in personal.xlsb file hence i am using macro free work book.