Using evaluate using same style formula but different row number

[Mr_Bill]

I would like to use vba to do the calculation and input the value in column D

So basically it works like this

Please Login or Register  to view this content.

I got as far as this

Please Login or Register  to view this content.

but if I use the fill handle to bring the dates down I get a mismatch error 13 on this line of code

Please Login or Register  to view this content.

*** forgot to mention this is suppose to be a event change so if the value in C changes it updates D


Thank you for looking

[6StringJazzer]

I think the logic is a bit muddled here. First, you have an If statement that tests that the Target is nonblank. Then you evaluate an Excel formula which again tests to see if it is blank. You have already determined that it is nonblank at this point, so do you do not even need the Evaluate. I would write this logic like this. I also simplified your first If statement. The one you had is not wrong, but takes the long way around.

Please Login or Register  to view this content.

[Mr_Bill]

Thank you Jazzer for your time. I am just going to use the formula in the cells. Not able to get this to work right. If I delete the date the countdown is still there. With the formula in the cell if i delete the date in c the number in d goes away also. I just have to be careful not delete the formula when I delete the other cells.

just a idea I had to make it easy on me
Workbook Idea if you see this you will see what I mean basic.

[6StringJazzer]

I see. I was just looking at your code rather than the big picture of what you are trying to accomplish. To blank out the count if the data is deleted you want this:

Please Login or Register  to view this content.

[Mr_Bill]

Thank you for this