UDFs evaluating to #NAME

If you add the code after you already have a formula in place that uses it, you need to force a recalculation.

Good afternoon malcmail

I can't reproduce your problem - works perfectly for me.

Would you be able to upload your workbook - you can get rid of most of the data, just leave a couple of dates to show as an example?

HTH

DominicB



Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitise the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Is the code in the same workbook as the formulas?

I'd suspect whoever used it previously disabled macros then. You could try calling either Application.CalculateFull or Application.CalculateFullRebuild in code, or if it's a small range or column/row of formulas, just use Find/Replace and replace = with = for those cells.