Value in Row

I'm trying to test that HearingDate(declared earlier in the code not on this page) is not blank and PET_EvidenceDue (also declared earlier) is blank, then replace PET_EvidenceDue with a formula, if true. I can't get the syntax of the integer (PET_EvidenceDue(i).Formula) for the resulting value in the For-Next loop correct. Where do I need to put the (i)? All my declared items are .databodyrange, fyi. The presence or no presence of the (i) is either erasing the column completely, just simply not running the test, or is applying the formula to the entire databodyrange.

Please Login or Register  to view this content.

How can I get this test to run the check and only put the formula in the appropriate columns? What am I doing wrong?

FYI- I can't use SpecialBlankCells or opposite for either column becaue neither are showing up as technically blank for some reason.

You need to post ALL your code, ideally in the workbook (rather than just posting an .xlsx file).

83 views and no replies is indicative of the fact that you are not providing all the relevant information, not unlike the other thread on this same topic

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-pro...or-blanks.html