Custom function (UDF) does not run when range parameter refers to self

Custom function (UDF) does not run when range parameter refers to self

Posted by: dean.kinnear on 15 April 2024, 1:11 pm EST

• 

  dean.kinnear

  • Post Options:
  • Link
    Copy

  Posted 15 April 2024, 1:11 pm EST

  in cell A1 of any sheet add custom function =UDF(A1)
  
  The UDF will run if I change the reference to anything but itself.
  
  Function returns #NAME? error.

  Thanks!

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 16 April 2024, 3:01 am EST

  Hi,

  I attempted to reproduce the issue on my end but was unable to do so. The custom function did not produce a #NAME error. Please see the sample below for reference.

  Sample: https://jscodemine.mescius.io/share/50e5ou1KSkiB9G4ExhKLAA/?IsEmbed=false&Theme=Unset&PreviewDirection=0&IsEditorShow=true&IsExplorerShow=true&IsPreviewShow=true&IsConsoleShow=true&IsRunBTNShow=false&IsResetBTNShow=false&IsOpenInCodemineBTNShow=false&PanelWidth=20&PanelWidth=50&PanelWidth=30&defaultOpen={"OpenedFileName"%3A["%2Findex.html"%2C"%2Fpackage.json"%2C"%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  #NAME error comes when text in a formula is not recognized or when the name of a function is misspelled, or when including text without using double quotation marks. This can also happen when you omit a colon in a cell range reference. This could potentially be one of the reasons for the error. However, without replicating the issue, I cannot confirm the exact nature of the problem. So to better assist you, could you share a sample along with the steps to replicate the behavior you have observed, or modify the existing sample to replicate the behavior? This will enable me to investigate the problem more thoroughly. And It would be helpful if you could provide a GIF or video illustrating the issue.

  Regards,
  
  Priyam