cells with formulas vb

I'm having trouble getting my vb to look at a cell in column"D" and if empty, populate it with a date/time stamp. The cells in "D" have a formula in it to populate with "N/A" if certain criteria are met and blank if not. The vb works great in cells "E" and "F", which have no formual, just not in "D". I suspect it has something to do with the formula being in the cell, or I'm missing something in the activecell statements in my vb below. I have added an attachment of my spreadsheet as well. Your assistance is always appreciated.

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Please accept my sincere apology for the error.

Please Login or Register  to view this content.