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.
Code:
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Dim EndRow As Integer
If ActiveSheet.UsedRange.Rows.Count = 0 Then
Exit Sub
End If
EndRow = Cells(65536, 1).End(xlUp).Row
Cells(EndRow + 1, 1).Activate
End Sub
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.