I can't see why that would happen, unless there was a problem with one of the named ranges.

What happens if you remove/comment out On Error Resume Next?