Tony,

I see nothing obviously wrong with your code. It should work. The only thing I could think of is that maybe that cell already had a comment, but in that case the error should be 1004 (application-defined or object-defined error).