macro recorder question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 *
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

code breaks in macro 1
cut/paste columns efficiency 13
Check to see if cell is blank 5
10 seconds to open excel workbook w/macros 1
works and doesn't work 2
events=false not acting? 2
Cleanup this macro please 3
Complicated Sort-Compare-Delete Question 4

Back
Top