Quote Originally Posted by mehmetcik View Post
Use the Macro recorder.

Press Ctrl and the Down Arrow.

Returns the following code:


    Selection.End(xlDown).Select
Thanks for ur code