End(xlUP) seems to me as a function

[lezawang]

Hi
I understand the code below what what I do not really understand is End(xlUp).
I read that it is a Property of Range and it is of type of Range itself. It is used to change the direction of a cell. But what I do not understand, why xlUp passed between 2 () to me that suggest it is a function/method, not property.

Thank you.

Sub abc()
    Dim x As Double
    x = Cells(Rows.Count, 1).End(xlUp).Row
    MsgBox x
End Sub

 

[Redoute]

One difference is, a property might be writable. Google finds more explanation, e. g. https://stackoverflow.com/questions/9728321/what-is-the-difference-between-a-parameterized-property-and-function-in-vb-net

 

[Joe4]

xlUp is NOT a function. You cannot pass any parameters/values to it.
xlUp is the equivalent to go to any range, and then pressing CTRL+Up Arrow, which goes to the first cell with data in it (when moving in that upward direction).
.Row just pulls the row number off of that range you just found and stopped in.

 

[mikerickson]

.End is a property, which is very much like a function.

xlUP is not a function, it is a value.

The .End property can take one of four arguments xlUp, xlDown, xlToRight or xlToLeft, depending on which direction one wants the End to seek its result.