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.

Jason, try this
Range("A65536").End(xlUp).Offset(1, 0).Select
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **


"Jason" wrote in 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.

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.
.