Copy highlighted.
I need a macro that will take whatever I highlight (left click) and append it to another file. Can that be done? Thank you for your help. Ken -- sungen99 ------------------------------------------------------------------------ sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144 View this thread: http://www.excelforum.com/showthread...hreadid=539344 |
Copy highlighted.
The macro recorder is your friend. Just modify
Sub Macro2() ' ' Macro2 Macro ' Macro recorded 5/5/2006 by Don Guillett ' ' ' Range("A13:A14").Select ' Selection.Copy 'Range("D12").Select ' ActiveSheet.Paste Application.CutCopyMode = False End Sub sub copyselected() selection.copy range("d12") end sub -- Don Guillett SalesAid Software "sungen99" wrote in message ... I need a macro that will take whatever I highlight (left click) and append it to another file. Can that be done? Thank you for your help. Ken -- sungen99 ------------------------------------------------------------------------ sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144 View this thread: http://www.excelforum.com/showthread...hreadid=539344 |
All times are GMT +1. The time now is 02:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com