Hi,

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:

Sheet 1
Column A Column B
1/1/2017 25
1/2/2017 26
1/3/2017 10
1/4/2017 #N/A
1/5/2017 #N/A
1/6/2017 12
1/7/2017 31
1/8/2017 55
1/9/2017 11
1/10/2017 12
… …
12/28/2017 69
12/29/2017 #N/A
12/30/2017 55
12/31/2017 11

Thank you for the help! Really appreciate the assit