Selecting A Range
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. |
Selecting A Range
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. |
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. . |
All times are GMT +1. The time now is 05:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com