Snoopy369 wrote:
the 0 column is probably blank

There is no 0 column
Each reference to it will have generated an error
On Error Resume Next means you didn't see the errors.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup