Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to next cell
Within macro code, I am trying to activate the cell
directly below the last cell in a single column list. I have used the following command: ActiveCell.SpecialCells(xlLastCell).Select ....but I then need to activate the next cell down. Can anyone help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to next cell
Hi Satch
ActiveCell.SpecialCells(xlLastCell).Offset(1,0).Se lect HTH Cordially Pascal "Satch" a écrit dans le message de ... Within macro code, I am trying to activate the cell directly below the last cell in a single column list. I have used the following command: ActiveCell.SpecialCells(xlLastCell).Select ...but I then need to activate the next cell down. Can anyone help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to next cell
Satch,
this should do the trick: Code: -------------------- ActiveCell.SpecialCells(xlLastCell).Select ActiveCell.Offset(1,0).Activate -------------------- Good luck --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to next cell
Hi Papou,
Thanks for your help. The suggested command actually made a seemingly random cell on the sheet active, rather than the next from last in a column. I applied the "Offset" part to a command that I had tried previously and this has worked, so thankyou very much for introducing me to that. The command used was: Selection.End(x1Down).Offset(1,0).Select Regards, Mark Satchwell |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to next cell
Glad to help Satch
Cordially Pascal "Satch" a écrit dans le message de ... Hi Papou, Thanks for your help. The suggested command actually made a seemingly random cell on the sheet active, rather than the next from last in a column. I applied the "Offset" part to a command that I had tried previously and this has worked, so thankyou very much for introducing me to that. The command used was: Selection.End(x1Down).Offset(1,0).Select Regards, Mark Satchwell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How move arrow keys from cell to cell and NOT entire col/rows | New Users to Excel | |||
How do I move from cell A 10 to cell B1 with one move or click | Excel Worksheet Functions | |||
The absolute referenced cell does not move when source cell moves | Excel Worksheet Functions | |||
Excel - arrow keys move whole sheet instead of from cell to cell | Excel Discussion (Misc queries) | |||
Arrow keys move screen instead of moving from cell to cell. | Setting up and Configuration of Excel |