Type Error Mismatch

[Jiptastic]

The majority of the time this sub works fine to paste the column heading to any cells that read "Blank". However, every now and then it errors
and reads "type mismatch". It highlights

Please Login or Register  to view this content.

Any ideas why?

Please Login or Register  to view this content.

[Norie]

You would get a type mismatch if Cells(x,y) contained a number or an error.