Hehe. We're probably in the minority on this board for using the .Cells() approach. Don't see it much in other people's code. I've always been a big fan of .Cells().Resize() because I'm always moving data in and out of variants containing arrays. You can always turn it into a normal-looking range with .Cells().Resize().Address