Thanks all for the replies - I'm very close to the solution. I went with the code suggested by cheeky and shg, though it seems the problem is that one of the fields I'm trying to clear is actually three cells merged and centered. When I run the macro from the worksheet, it returns an error that only reads "400", so I tried running it from the VBA Editor, and it errors: Cannot change part of a merged cell." Is it generally bad practice to use merged cells? I merged them to take advantage of available space in the "UI" and would prefer not to un-merge them... any bright ideas?