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

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

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