| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select last cell in range
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 i a load of new data. I can use Selection.End(xlDown) fine to get to the last cell, but the I want to offset one cell down. The code I have for the offset i Cell.Offset(1,0).Select, but this comes back with an error saying i needs an object. Any ideas on what I'm doing wrong? Thanks Pau -- 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
