View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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.
.