Hi Divaker, If you mean the last two things copied within Excel, and you want to identify them from VBA,
Take a look at http://www.mrexcel.com/forum/showthread.php?t=167292 Keep in mind that the commandbar containing the Office Clipboard's name varies by Excel version. Here's how I think it goes: In Office 2000 reference the "Clipboard" commandbar. In Office XP through perhaps I guess Office 2003, reference the "Task Pane" commandbar. In perhaps Office 2007 through 2010 or 2011 (noted in Office 2010), reference the "Office Clipboard" commandbar. You might also try using the macro recorder to work with those items and see what you get. I have not tried this, but I saw the tip "Each of the MicrosoftR Office XP applications provides a Clipboard toolbar that you can use to store up to 12 items. In addition, you can work with the items stored by the Clipboard toolbar programmatically through the command bar object model. The last item copied to the Clipboard toolbar is the one stored in the Windows Clipboard." at http://msdn.microsoft.com/en-us/library/aa189708%28v=office.10%29.aspx, but without further elaboration. Additional web searches might find you other/better examples. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Divaker Pandey Sent: Monday, March 19, 2012 4:53 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ last copied item in windows clipboard Hi Expert, Can anyone give me a hint to findout last and second last copied item. Divaker -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com