Opening a WB to a specific (the next empty)cell 
Author Message
 Opening a WB to a specific (the next empty)cell

I'm just finishing an XL2000 WB and I would like my auto-open macro to bring
the cell pointer to the first blank cell in a column. Data from the prior
days work will be in the column and the first blank cell in the column will
vary from day to day.

So- how do I get the WB to open with the cell-pointer where I want it ?

Thanks for your help.

Bob



Sun, 26 Sep 2004 02:12:17 GMT  
 Opening a WB to a specific (the next empty)cell
Bob

You can use a statement like

ThisWorkbook.Sheets("Sheet1").Activate
Range("A65000").End(xlUp).Offset(1,0).Select

Of course, if you only have 1 sheet, you won't need the first line

--
{*filter*} Kusleika
MVP - Excel

Post all replies to the newsgroup.


Quote:
> I'm just finishing an XL2000 WB and I would like my auto-open macro to
bring
> the cell pointer to the first blank cell in a column. Data from the prior
> days work will be in the column and the first blank cell in the column
will
> vary from day to day.

> So- how do I get the WB to open with the cell-pointer where I want it ?

> Thanks for your help.

> Bob



Sun, 26 Sep 2004 02:19:48 GMT  
 Opening a WB to a specific (the next empty)cell
Wow - that was a fast reply, and a cool solution.
The range I'm working with is c3..c100 (shud have told you that) so I will
try to change "a65000" to "c3..c100" which hopefully will work.
Thanks again, Bob

Quote:
> Bob

> You can use a statement like

> ThisWorkbook.Sheets("Sheet1").Activate
> Range("A65000").End(xlUp).Offset(1,0).Select

> Of course, if you only have 1 sheet, you won't need the first line

> --
>{*filter*} Kusleika
> MVP - Excel

> Post all replies to the newsgroup.



> > I'm just finishing an XL2000 WB and I would like my auto-open macro to
> bring
> > the cell pointer to the first blank cell in a column. Data from the
prior
> > days work will be in the column and the first blank cell in the column
> will
> > vary from day to day.

> > So- how do I get the WB to open with the cell-pointer where I want it ?

> > Thanks for your help.

> > Bob



Sun, 26 Sep 2004 02:49:33 GMT  
 Opening a WB to a specific (the next empty)cell
OK{*filter*}, I actually figured it out from there by checking the help file for
RANGE and now I understand what you meant. In my case the range is c4.c100
so I just used c100 for the range and it works UP from there. Thanks again,
works just fine and I learned something with your help.
Bob

Quote:
> Wow - that was a fast reply, and a cool solution.
> The range I'm working with is c3..c100 (shud have told you that) so I will
> try to change "a65000" to "c3..c100" which hopefully will work.
> Thanks again, Bob


> > Bob

> > You can use a statement like

> > ThisWorkbook.Sheets("Sheet1").Activate
> > Range("A65000").End(xlUp).Offset(1,0).Select

> > Of course, if you only have 1 sheet, you won't need the first line

> > --
> >{*filter*} Kusleika
> > MVP - Excel

> > Post all replies to the newsgroup.



> > > I'm just finishing an XL2000 WB and I would like my auto-open macro to
> > bring
> > > the cell pointer to the first blank cell in a column. Data from the
> prior
> > > days work will be in the column and the first blank cell in the column
> > will
> > > vary from day to day.

> > > So- how do I get the WB to open with the cell-pointer where I want it
?

> > > Thanks for your help.

> > > Bob



Sun, 26 Sep 2004 03:48:51 GMT  
 Opening a WB to a specific (the next empty)cell
Bob

Glad you got it working.

--
{*filter*} Kusleika
MVP - Excel

Post all replies to the newsgroup.


Quote:
> OK{*filter*}, I actually figured it out from there by checking the help file
for
> RANGE and now I understand what you meant. In my case the range is c4.c100
> so I just used c100 for the range and it works UP from there. Thanks
again,
> works just fine and I learned something with your help.
> Bob


> > Wow - that was a fast reply, and a cool solution.
> > The range I'm working with is c3..c100 (shud have told you that) so I
will
> > try to change "a65000" to "c3..c100" which hopefully will work.
> > Thanks again, Bob


> > > Bob

> > > You can use a statement like

> > > ThisWorkbook.Sheets("Sheet1").Activate
> > > Range("A65000").End(xlUp).Offset(1,0).Select

> > > Of course, if you only have 1 sheet, you won't need the first line

> > > --
> > >{*filter*} Kusleika
> > > MVP - Excel

> > > Post all replies to the newsgroup.



> > > > I'm just finishing an XL2000 WB and I would like my auto-open macro
to
> > > bring
> > > > the cell pointer to the first blank cell in a column. Data from the
> > prior
> > > > days work will be in the column and the first blank cell in the
column
> > > will
> > > > vary from day to day.

> > > > So- how do I get the WB to open with the cell-pointer where I want
it
> ?

> > > > Thanks for your help.

> > > > Bob



Sun, 26 Sep 2004 04:46:53 GMT  
 Opening a WB to a specific (the next empty)cell
Bob, if you're still there, you may want to leave the number as C65536.

Dick's code starts at the bottom of the sheet and goes up to the first non-empty
cell it finds.

Even if you don't think you'll exceed C100, it won't hurt to start at the very
bottom.  And if you do put something in C101, you'll be happy you made it very
large.

Quote:

> OK{*filter*}, I actually figured it out from there by checking the help file for
> RANGE and now I understand what you meant. In my case the range is c4.c100
> so I just used c100 for the range and it works UP from there. Thanks again,
> works just fine and I learned something with your help.
> Bob


> > Wow - that was a fast reply, and a cool solution.
> > The range I'm working with is c3..c100 (shud have told you that) so I will
> > try to change "a65000" to "c3..c100" which hopefully will work.
> > Thanks again, Bob


> > > Bob

> > > You can use a statement like

> > > ThisWorkbook.Sheets("Sheet1").Activate
> > > Range("A65000").End(xlUp).Offset(1,0).Select

> > > Of course, if you only have 1 sheet, you won't need the first line

> > > --
> > >{*filter*} Kusleika
> > > MVP - Excel

> > > Post all replies to the newsgroup.



> > > > I'm just finishing an XL2000 WB and I would like my auto-open macro to
> > > bring
> > > > the cell pointer to the first blank cell in a column. Data from the
> > prior
> > > > days work will be in the column and the first blank cell in the column
> > > will
> > > > vary from day to day.

> > > > So- how do I get the WB to open with the cell-pointer where I want it
> ?

> > > > Thanks for your help.

> > > > Bob

--

Dave Peterson



Sun, 26 Sep 2004 06:19:57 GMT  
 
 [ 6 post ] 

 Relevant Pages 

1. XL97: How to copy into next blank cell text from 1st non-empty cell

2. Subroutine: copy into next blank cell text from 1st non-empty cell, loop-copy until next non-empty

3. Excell wb not open, too many dif cell formats

4. Finding Next Empty cell in a column

5. Activating The Next Empty Cell

6. Copying Block of Data to Next Empty Cell

7. Name next empty cell down in column A

8. Find next empty cell

9. Setting value in "next empty cell"

10. shift focus to next non-empty cell


 
Powered by phpBB® Forum Software © phpBB Group