instead of trying to write "... = null"

try "... = vbNullString" I'm not sure if this is write, but it may work.