Write Range: Object reference not set to an instance of an object

[Cedrik]

I wrote a solution to a newer thread with the same issue (here), but writing here too because this appears to be the topmost Google result.