I still cannot reproduce this issue on that line.

Do you have Microsoft Excel reference library selected?

Disable the On Error Resume Next and step debug your code.