User Defined Function Call Error

[Paul_Hossler]

since the report that contains the data comes out of IBM Cognos I cannot change it to a .xlsm.

A. Couldn't you

1. take the Cognos XLSX and FileSaveAs it as a XLSM
2. Use the VBE to insert a standard macro sheet
3. put the code on that?

Since the purpose of the sub AutomatedPickLog is to enter formulas using the AreaOwner function, you would need AreaOwner on the Cognos WB at least

OR

B. you could just have AutomatedPickLog put the value instead of the formula in the Cognos WB