Posted 8 September 2017, 1:42 pm EST
When attempting to paste (by value) a string into a numeric cell type, the paste fails without any obvisious notification. The cell does not change but there must be some internal validation going on that the cell decides not to paste that data.
Is there an event or calc error type code that can be watched for to notify the user that the action was invalid? I'm looking to capture this failure and display a message box to the user that their paste was invalid.