Excel 2007 User defined fucntion, cannot paste in mutiple cells
 

I have created a macro function that I cannot paste in mutiple cells. I can
copy and paste on a cell by cell basis, the formual updates. It does not
update if I paste in mutiple cells without using the insert formual on the
ribbon bar - anyone have a solution. Macor security is set to enable all.