macro?
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 |
All times are GMT +1. The time now is 06:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com