Thread
:
Copy highlighted.
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
Posts: n/a
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 With Quote