Home |
Search |
Today's Posts |
#1
|
|||
|
|||
select a range using "cells()"
Rather than using the range function to select multiple cells, ie:
Range("A1:B6").Select Is there a way to use - Cells() instead. This is because the number of cells will change. Thanks |
#2
|
|||
|
|||
Range(Cells(1,1),Cells(6,2)).Select
or Range(Cells(1,"A"),Cells(6,"B").Select or Cells(1,"A").Resize(6,2).Select or ... etc. -- HTH Bob Phillips "fullers" wrote in message ... Rather than using the range function to select multiple cells, ie: Range("A1:B6").Select Is there a way to use - Cells() instead. This is because the number of cells will change. Thanks |
#3
|
|||
|
|||
Bob Phillips wrote:
Range(Cells(1,1),Cells(6,2)).Select or Range(Cells(1,"A"),Cells(6,"B").Select or Cells(1,"A").Resize(6,2).Select or ... Set rng = Range("A1") Range(rng(1,1),rng(6,2)).Select Alan Beban |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting empty cells within a range of cells | New Users to Excel | |||
automatically fill in a range of cells | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel | |||
I want to select excel cells of difference colors and increase th. | Excel Worksheet Functions | |||
Merging Cells but have each cell counted in the range of merged c. | Excel Worksheet Functions |