How to cause the program not to display the message #ARG, though the field contains a reference to a cell that contains text instead of numbers?

[mariusz.kurasinski.3]

How to cause the program not to display the message #VALUE, though the field contains a reference to a cell that contains text instead of numbers?