Selecting A Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 **
 
hi,
Range("A2").Select
Selection.CurrentRegion.Select
note: useing this method, there can be no data in cells
adjacent to your range of cells.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Combine 2 columns in a dynamic range into one 7
Copying all whilst Range Forbidden active 8
copying dynamic range based on cell outside of range 3
Code to Concat a row in loop 2
Error Message - Macro to Unlink MS Queries from Workbook 0
Selecting/copying a dynamic range in VB 1
Post my named ranges in column A 10

Back
Top