lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]1[/TD]
[/TR]
[TR]
[TD]22[/TD]
[/TR]
[TR]
[TD]33[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
</tbody>[/TABLE]
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="]Returns a [/FONT][FONT="]Range[/FONT][FONT="] 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="]Range[/FONT][FONT="] object.
[/FONT]https://docs.microsoft.com/en-us/office/vba/api/excel.range.end
for example if I have
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]1[/TD]
[/TR]
[TR]
[TD]22[/TD]
[/TR]
[TR]
[TD]33[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
</tbody>[/TABLE]
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="]Returns a [/FONT][FONT="]Range[/FONT][FONT="] 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="]Range[/FONT][FONT="] object.
[/FONT]https://docs.microsoft.com/en-us/office/vba/api/excel.range.end