How can I reference a range using the cells property? I know how to refer to one cell, but not a group. Here's my attempt:


Range("A1:A10").select   =    Cells(1,1:10,1).select
my attempt sucks-