Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Cut & Copy then restore on exiting | Excel Discussion (Misc queries) | |||
copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
Ignoring highlighted cells | Excel Worksheet Functions | |||
Copy shortcut | Excel Worksheet Functions | |||
Copy without Hidden Cols - How | Excel Discussion (Misc queries) |