Export (0) Print
Expand All
E
EndArrowheadStyle Property
EndArrowheadWidth Property
EndConnected Property
EndConnectedShape Property
EndConnectionSite Property
EndStyle Property
EntireColumn Property
EntireRow Property
EnvelopeVisible Property
ErrorBars Property
ErrorCheckingOptions Property
ErrorMessage Property
Errors Property
ErrorString Property
ErrorTitle Property
EvaluateToError Property
Excel4IntlMacroSheets Property
Excel4MacroSheets Property
ExpandHelp Property
Explosion Property
ExtendList Property
Extent Property
ExtrusionColor Property
ExtrusionColorType Property
Expand Minimize
7 out of 12 rated this helpful - Rate this topic

End Property [Excel 2003 VBA Language Reference]

Office 2003

Returns a Range 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 Range object.

expression.End(Direction)

expression Required. An expression that returns one of the objects in the Applies To list.

XlDirection can be one of these XlDirection constants.
xlDown
xlToRight
xlToLeft
xlUp

Example

This example selects the cell at the top of column B in the region that contains cell B4.

Range("B4").End(xlUp).Select
		

This example selects the cell at the end of row 4 in the region that contains cell B4.

Range("B4").End(xlToRight).Select
		

This example extends the selection from cell B4 to the last cell in row four that contains data.

Worksheets("Sheet1").Activate
Range("B4", Range("B4").End(xlToRight)).Select
		


Applies to | Range Collection


Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.