"Move to bottom of range"
in [Programming]
|
From: Copacetic on 18 Apr 2010 04:23 Hello, I have some code that adds the contents of one sheet to the end of another. How do I correctly select the first empty cell below the first sheet that I want to add data to? Something like ActiveCell.SpecialCells(xlLastCell).Select 'Move to bottom of range ^^^ This is where I need work. Can I simply perform a cursor key move down one cell? How do I code cursor key operations?
From: Mike H on 18 Apr 2010 05:20 Hi, It is very unlikely that you will need to select a cell to do what you want but here's a couple of methods Select empty cell after last used cell in col A Range("A" & Cells(Cells.Rows.Count, "A").End(xlUp).Row + 1).Select Select empty cell in Col A below the last use cell on worksheet Range("A" & Cells.SpecialCells(xlLastCell).Row + 1).Select -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Copacetic" wrote: > Hello, > > I have some code that adds the contents of one sheet to the end of > another. How do I correctly select the first empty cell below the first > sheet that I want to add data to? > > Something like > > ActiveCell.SpecialCells(xlLastCell).Select > > 'Move to bottom of range > > ^^^ This is where I need work. > > Can I simply perform a cursor key move down one cell? > > How do I code cursor key operations? > . >
From: Ron de Bruin on 18 Apr 2010 05:24 See also http://www.rondebruin.nl/last.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mike H" <MikeH(a)discussions.microsoft.com> wrote in message news:0CE00896-559C-4C7A-BFAB-590C4FB93AD5(a)microsoft.com... > Hi, > > It is very unlikely that you will need to select a cell to do what you want > but here's a couple of methods > > Select empty cell after last used cell in col A > Range("A" & Cells(Cells.Rows.Count, "A").End(xlUp).Row + 1).Select > > Select empty cell in Col A below the last use cell on worksheet > Range("A" & Cells.SpecialCells(xlLastCell).Row + 1).Select > -- > Mike > > When competing hypotheses are otherwise equal, adopt the hypothesis that > introduces the fewest assumptions while still sufficiently answering the > question. > > > "Copacetic" wrote: > >> Hello, >> >> I have some code that adds the contents of one sheet to the end of >> another. How do I correctly select the first empty cell below the first >> sheet that I want to add data to? >> >> Something like >> >> ActiveCell.SpecialCells(xlLastCell).Select >> >> 'Move to bottom of range >> >> ^^^ This is where I need work. >> >> Can I simply perform a cursor key move down one cell? >> >> How do I code cursor key operations? >> . >>
From: Per Jessen on 18 Apr 2010 05:24 ActiveCell.SpecialCells(xlLastCell).Offset(1,0).Select Or like this: Range("A1").End(xlDown).Offset(1,0).Select Regards, Per On 18 Apr., 10:23, Copacetic <Copace...(a)iseverythingalright.org> wrote: > Hello, > > I have some code that adds the contents of one sheet to the end of > another. How do I correctly select the first empty cell below the first > sheet that I want to add data to? > > Something like > > ActiveCell.SpecialCells(xlLastCell).Select > > 'Move to bottom of range > > ^^^ This is where I need work. > > Can I simply perform a cursor key move down one cell? > > How do I code cursor key operations?
From: Copacetic on 18 Apr 2010 10:26 Right on the money. Thanks. On Sun, 18 Apr 2010 02:24:34 -0700 (PDT), Per Jessen <perjessen69(a)hotmail.com> wrote: >ActiveCell.SpecialCells(xlLastCell).Offset(1,0).Select > >Or like this: > >Range("A1").End(xlDown).Offset(1,0).Select > >Regards, >Per > >On 18 Apr., 10:23, Copacetic <Copace...(a)iseverythingalright.org> >wrote: >> Hello, >> >> �I have some code that adds the contents of one sheet to the end of >> another. How do I correctly select the first empty cell below the first >> sheet that I want to add data to? >> >> � Something like >> >> � � ActiveCell.SpecialCells(xlLastCell).Select >> >> 'Move to bottom of range >> >> � ^^^ This is where I need work. >> >> � Can I simply perform a cursor key move down one cell? >> >> � How do I code cursor key operations?
|
Next
|
Last
Pages: 1 2 3 4 Prev: A formula for subtotals against each category Next: fractions to decimal |