Selecting A Range
hi,
Range("A2").Select
Selection.CurrentRegion.Select
note: useing this method, there can be no data in cells
adjacent to your range of cells.
-----Original Message-----
I'm fairly new to this, so please bear with me... Assume
I have a worksheet
with a range of cells (let's say "A2:G10"). What I
would like to do, is
write some code that will look at the range of cells and
then will select the
cell in column A which is the first open cell (i.e. the
first open row).
Note that the range may be dynamic, and will not always
be A2:G10, although
the beginning point will always be A2. Thanks.
.
|