Run-time error 1004

[Phrone]

I have a workbook with over 900 worksheets.

The macro I have is looping all sheets looking for empty cells in a specific column, and when it founds an empty cell the value for one cell is copied to the empty cell.
But in one worksheet it stops with the error:

Run-time error '1004'
Application-defined or object-defined error

And the row in the macro is:

Please Login or Register  to view this content.

The only difference in this worksheet is that cell 5,15 have more characters, about 1000, in the sheet that throws the error. And if I remove all text in the cell no error is thrown.

How can I solve this problem?
Can I change my code so it skips all cells that throws an error so it continues running to the last sheet?

[Andy Pope]

You could try this

Please Login or Register  to view this content.

[Phrone]

Thanks Andy.
Now the macro is working perfectly.