END or CTRL?

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,488
Hi in the article below, MS said End+Up arrow, End+down arrow. Is that right? or it should be Ctrl + down/up arrow? I do not see they are the same?

for example if I have

1
22
33
44

<tbody>
</tbody>


and if I am in cell A1 then CTRL+down arrow, will go to A4 then another CTRL+down will go to the end.
While END+down arrow, will go first from A1 to A4 and another End+downarrow will go to A5.


[h=1]Range.End property (Excel)[/h][FONT=&quot]Returns a [/FONT][FONT=&quot]Range[/FONT][FONT=&quot] object that represents the cell at the end of the region that contains the source range. Equivalent to pressing END+UP ARROW, END+DOWN ARROW, END+LEFT ARROW, or END+RIGHT ARROW. Read-only [/FONT][FONT=&quot]Range[/FONT][FONT=&quot] object.

[/FONT]
https://docs.microsoft.com/en-us/office/vba/api/excel.range.end
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
7,673
Office Version
2007
Platform
Windows
I tried and end and down = ctrl + down
 

Forum statistics

Threads
1,077,649
Messages
5,335,473
Members
399,017
Latest member
npatel917

Some videos you may like

This Week's Hot Topics

Top