| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Selection
I am trying to add text after the last row that has data. I can get to the
last occupied cell with the command Selection.End(xlDown).Select How do I get to the next cell below? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell Selection
Using what you have here you would want to add the following line of code...
Selection.End(xlDown).Select activecell.offset(1,0).select or you could just modify the current line of code as follows: Selection.End(xlDown).offset(1,0).Select HTH "Chris" wrote: I am trying to add text after the last row that has data. I can get to the last occupied cell with the command Selection.End(xlDown).Select How do I get to the next cell below? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell Selection
Chris
Selection.End(xlDown).Offset(1,0).Select Regards Trevor "Chris" wrote in message ... I am trying to add text after the last row that has data. I can get to the last occupied cell with the command Selection.End(xlDown).Select How do I get to the next cell below? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell Selection
Thanks.
"Jim Thomlinson" wrote: Using what you have here you would want to add the following line of code... Selection.End(xlDown).Select activecell.offset(1,0).select or you could just modify the current line of code as follows: Selection.End(xlDown).offset(1,0).Select HTH "Chris" wrote: I am trying to add text after the last row that has data. I can get to the last occupied cell with the command Selection.End(xlDown).Select How do I get to the next cell below? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
| Force entry into cell, based on validation selection in adjacent cell | Excel Worksheet Functions | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| Lock data in a cell a specific cell based on selection on other ce | Excel Worksheet Functions | |||
| limit cell list selection based on the selection of another list | Excel Worksheet Functions | |||
Linear Mode
