Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro recorder question
hi i have recorded a simple macro where i cut a column and paste it somewhere else. this is the code the recorder gives me
Columns("D:D").Cu Columns("A:A").Selec ActiveSheet.Past Is there a more efficient way of writing this. I tried without the select and just paste but that doesn't work Thk |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro recorder question
Hi
try Columns("D:D").Cut Columns("A:A").Paste -- Regards Frank Kabel Frankfurt, Germany kevin wrote: hi i have recorded a simple macro where i cut a column and paste it somewhere else. this is the code the recorder gives me. Columns("D:D").Cut Columns("A:A").Select ActiveSheet.Paste Is there a more efficient way of writing this. I tried without the select and just paste but that doesn't work. Thks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro recorder question
Or the even more concise: Columns("D").Cut Columns("A") -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "Frank Kabel" wrote in message ... Hi try Columns("D:D").Cut Columns("A:A").Paste -- Regards Frank Kabel Frankfurt, Germany kevin wrote: hi i have recorded a simple macro where i cut a column and paste it somewhere else. this is the code the recorder gives me. Columns("D:D").Cut Columns("A:A").Select ActiveSheet.Paste Is there a more efficient way of writing this. I tried without the select and just paste but that doesn't work. Thks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro recorder and formulas | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Macro recorder | Excel Discussion (Misc queries) | |||
Steps from Macro recorder for Pivot table will not run as a Macro | Excel Programming |