hi,
i have programmed the formula below formula for my reports..however i get an error msg which says
"Runtime Error 1004: Application or object defined error"
Range("L276").formula = "=IF(H276<M276,((H276*$J$3)+(M276*(12-$J$3)))/12,((H276*$J$3)+(H276*(12-$J$3)))/12"
i have also defined my worksheet that should be called...
what could be my mistake?
i have programmed the formula below formula for my reports..however i get an error msg which says
"Runtime Error 1004: Application or object defined error"
Range("L276").formula = "=IF(H276<M276,((H276*$J$3)+(M276*(12-$J$3)))/12,((H276*$J$3)+(H276*(12-$J$3)))/12"
i have also defined my worksheet that should be called...
what could be my mistake?