VBA Select End of Range

Hello all,

I am looking for a code that selects the last cell of a pasted range. Within excel you can do this with Shift+Enter shortcut so I'm basically looking to do this with a vba code.

Thank you,

Yusuf

Maybe:

Sub Yusuf_Ali()
Cells(Selection.Rows.Count, Selection.Column).Select
End Sub

Originally Posted by JOHN H. DAVIS

Maybe:

Sub Yusuf_Ali()
Cells(Selection.Rows.Count, Selection.Column).Select
End Sub

Perfect, exactly what I was looking for! Thank you very much for help John.

You're welcome. Glad to help out and thanks for the feedback. Please mark this thread as solved.