Robert, thanks for your suggestions. It looks like the problem was indeed that there was no data in those cells. Since I could set one range successfully on blank data I assumed that was the case generically. Obviously not, and I can't see that documented anywhere. Never mind, I think I have it beaten now. Thanks for all your help, Gavin