macro?

[Guest]

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

 

[Chip Pearson]

Try something like

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


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


"VBA12thRoundDraftPick"
message
news:[email protected]...

 

[Guest]

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

 

[Gord Dibben]

sub cut_this()

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

end sub


Gord Dibben Excel MVP