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:
my attempt sucks-![]()
Range("A1:A10").select = Cells(1,1:10,1).select
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:
my attempt sucks-![]()
Range("A1:A10").select = Cells(1,1:10,1).select
How about for A1 to J1 would be:
Or![]()
Range(Cells(1,1),Cells(1,10)).Select
A1 to A10 would be:
![]()
Range(Cells(1,1),Cells(10,1)).Select
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Yep. Perfecto!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks