VBA code calling UDF - VALUE errors

[buck1112]

Hi,
I'm working with VBA code in a module, but I am getting #VALUE? errors for some reason in the cells, and not the result of the formulas.
Thanks for any help you can provide. Here (below) are the codes.

Please Login or Register  to view this content.

[shg]

Welcome to the forum.

You're trying to insert an A1 formula with the FormulaR1C1 property.

Also, the function doesn't need any error handling.

Please Login or Register  to view this content.

[buck1112]

Thanks for your help in this!