I've added to my Excel file a new property prop.

picture of my property from the settings

I would now like to use the property in a formula, like =VERKETTEN(""; prop; "").

But this doesn't work :( Is there a way to use those properties in formula?

CodePudding user response：

You can't directly use the property in a formula, you'd have to use a macro or UDF, and reference the