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

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
dguillett1@austin.rr.com
"sungen99" <sungen99.27cftb_1146847807.2256@excelforum-nospam.com> wrote in
message news:sungen99.27cftb_1146847807.2256@excelforum-nospam.com...
>
> 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
>