Home |
Search |
Today's Posts |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Move to bottom of range"
See also
http://www.rondebruin.nl/last.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mike H" wrote in message ... 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? . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off "CALCULATE" on bottom of Excel worksheet. near "Ready" | Excel Discussion (Misc queries) | |||
extract range with same weeks and move to "calendar" | Excel Programming | |||
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
compare ranges in different workbooks and copy "not matching values" at bottom of range 1 | Excel Programming | |||
copy a range of cells (a row) to the bottom of a "list" | Excel Programming |