| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select last cell in range
Hi
Just put the offset bit directly after. eg Selection.End(xlDown).Offset(1, 0).Select -----Original Message----- I can't remember how I did this last time..... I've got a range of cells and I need to go to the last cell to paste in a load of new data. I can use Selection.End(xlDown) fine to get to the last cell, but then I want to offset one cell down. The code I have for the offset is Cell.Offset(1,0).Select, but this comes back with an error saying it needs an object. Any ideas on what I'm doing wrong? Thanks Paul --- Message posted from http://www.ExcelForum.com/ . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select the first cell of the last row in a range - Excel 2003 | New Users to Excel | |||
| how can I select a range of cells based on a value of a cell? | Excel Discussion (Misc queries) | |||
| select first cell in unmerged range | Excel Discussion (Misc queries) | |||
| How to select a range whose name is entered in a cell. | Excel Worksheet Functions | |||
| select last cell in used range | Excel Programming | |||
Threaded Mode
