Sheet doesn't recalculate after picking from list including own function (EXAMPLE INCL.)

Hello.

In the attached workbook is small example cotaining user function (returning name of the cell) and after picking from the data validation list the formulas in the sheetshall display czech or english text in specified cells.

The function in the cell work perfectly, but when I change a value in the language list (this value is input for the function), the cell doesn't return expected text and returns #VALUE. After manual clicking F2+Enter it works as expected. I would like to have it automattical.

Tank you for your help.

Karel

Hello.

I received answer in another forum that has solved this issue so I'm sharing it below:

Instead of ActiveCell, use Application.ThisCell:
- returns the cell in which the user-defined function is being called from as a Range object.

Please Login or Register  to view this content.

Thank you tanasedn for your support and approach.