I didn't record these macros, I wrote them. There are two subs. Good() works. Bad() doesn't. The difference is, Bad() is trying to write text into another cell of the table. For some reason, the form field bookmark value doesn't save when I run Bad(), but it does save when I run Good().

But, a table with empty cells does me no good, and form fields with no bookmark value creates horrors I'm trying to avoid.

Now mind you, there are a dozen ways to do any single thing in VBA. Some methods are deprecated, some are just redundant. Some have side effects, some don't. If you see any section of my code that you would do differently, let me know. I don't mind changing it if it will fix the problem. Some of the code is how I would do things, some of it was how the guy before me was doing it.