Unable to add formulas such as =Put Delta, Call Delta etc in Excel 2013

[Jobs001]

Hi All,

I am trying to copy formulas from an excel sheet to a new sheet, but the formulas are not working. I have attached the original excel sheet for the reference.

Help me guys.

Thank you ,

Jobin Jose

 

[Deepak]

I think you are unable to copy the said formulas to another workbook as these are UDF.

To cover up the issue, have a read of the below will help!

https://support.microsoft.com/en-us/kb/141288

http://stackoverflow.com/questions/...unction-from-another-specific-workbook-in-vba

​

In the workbook you want to call from (I'll call this A), you could add a reference to the workbook that you want to call to (I'll call this B) as follows:

1. 
   
   • In workbook A, open the Microsoft Visual Basic for Applications window (for example, by pressing Alt+F11).
   • Select Tools, References.
   • In the References dialog that appears, choose Browse.
   • In the Add Reference dialog that appears, choose Microsoft Excel Files from the Files of type box, select the file that you want to call (B), and choose Open.
   • Choose OK to close the References dialog.

In file A, you should then be able to call public module-level functions in file B as if they were in file A. To resolve any naming conflicts, you can prefix calls by the "Project Name" for file B as specified in the General tab of the Project Properties dialog (accessible via the Properties command in the Microsoft Visual Basic for Applications Tools menu). For example, if the "Project Name" for file B was "VBAProjectB", you could call function F from file A using the syntax VBAProjectB.F.

 

[Jobs001]

Hi Deepak,
Thank you for the response. I tried the above and was unsuccessful . I am just a beginner and have no or nil knowledge about VBA.

Can you help me to paste the UDF to the attached excel sheet.

Thank you in advance.

 

[NARAYANK991]

Hi ,

I am not sure I have understood you , but I have copied the UDF from your initial file into this one.

Now you can use the UDFs in the workbook.

Narayan

 

[Jobs001]

Awesome.. That works.. Great work.. Thank you so much..