Hello

I've got the problem to get defined

NamedReferences

to apply as "validation dropdown"-lists into another worksheet.

I tried ... ".ApplyFormula("=Name_User");

But when i open the excel workbook i could only found the first entry of the NamedReference as value in the applied cell.

Can someone help me on the right way.

Greetings from germany

Dietrich