I need help clearing the contents of a cell based on current contents of cell via a macro. I would like to have the flexibility to identify 1) The Sheet Name 2) The column of the specific sheet 3) The criteria to identify (in the instance below #N/A). Once those are established - Delete all Contents - like the clear all function.
Why, one may ask do I want to delete the entire contents of the cell as oppose to using formula logic to change the output. The answer is simply I'm trying to graph this data with a line chart and if the cell is #N/A it makes the line chart look contiguous by connecting the 10 to the 12 in the setup below. I would like it to instead just leave the dates 1/4/17 and 1/5/17 blank and leave a "lineless" void between 10 and 12.
Here is the setup:
Column A Column B
Thank you for the help! Really appreciate the assit