Hi All

i am trying to get values into a macro through function procedure but getting run time error 1004 "Application defined or object defined error" below is code i am using:
Range("K2:K" & lrd).FormulaR1C1 = "=LP(RC[-7])]"
here LP is the function name. i am using same function procedure as a formula in excel and it works fine. any help would be great.
thanks