How would a macro read if you highlighted an area then run a macro that would
cut and paste that area to a specific location?

any help would be appreciated thank you

Try something like

Selection.Cut Destination:=Range("K10")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"VBA12thRoundDraftPick"
wrote in
message
...
How would a macro read if you highlighted an area then run a
macro that would
cut and paste that area to a specific location?

any help would be appreciated thank you

I tried that and received a compile error! any other ideas?

"VBA12thRoundDraftPick" wrote:

How would a macro read if you highlighted an area then run a macro that would
cut and paste that area to a specific location?

any help would be appreciated thank you

sub cut_this()

Selection.Cut Destination:=ActiveSheet.Range("K43")

end sub


Gord Dibben Excel MVP

On Fri, 1 Apr 2005 11:25:03 -0800, VBA12thRoundDraftPick
wrote:

How would a macro read if you highlighted an area then run a macro that would
cut and paste that area to a specific location?

any help would be appreciated thank you