Thanks John, your code suggestion and the change to make it work with Excel VBA totally fixed the problem. Many thanks again, this really helped. Can't say enough good things about this forum.