?ActiveCell

[lezawang]

Hi
I copied the code below from a website and it works fine and I got an idea what it does. But I tried to understand what "ActiveCell" returns. So I did the following in the immediate window

?ActiveCell

and I got the "Hi" which is the content of the cell A1 that is selected? if that is the case, why the code below works? I thought ActiveCell should return A1

Thank you

Sub selecttoend()    
    Range(ActiveCell, ActiveCell.End(xlDown)).Select
End Sub

 

[6StringJazzer]

ActiveCell is a Range object. A Range object has a default attribute of Value. So you refer to ActiveCell, it's the same thing as referring to ActiveCell.Value.

If you want to see the address of the active cell then use

?ActiveCell.Address(false,false)