Thanks for your reply. You know how you may have text with data within Outlook and you want to copy and paste them into a spreadsheet. As soon as one block of data is pasted, you have to go back to the source and then back to the spreadsheet find the end of the data previously pasted and then paste in the new block of data. I was thinking that if there a worksheet event that would advance the MS Excel to end of the previously pasted range to facilitate the new range about to pasted.
I have posted my code to facilitate what I envisioned. The caveat to this macro is that the user would have to right click and then select paste for the code to execute. Conversely, if the user did a ctrl + v then we are back at square one.
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Dim EndRow As Integer
If ActiveSheet.UsedRange.Rows.Count = 0 Then
EndRow = Cells(65536, 1).End(xlUp).Row
Cells(EndRow + 1, 1).Activate