Posted to microsoft.public.excel.programming

Bob

external usenet poster

Posts: 972

More efficient code

I need to move column E over to column A (column A is empty). Is there a
more efficient way (ideally using 1 line of code) to write the code for this
operation other than:

ActiveSheet.Columns("E:E").Cut
ActiveSheet.Range("A1").Select
ActiveSheet.Paste

Thanks in advance for any help.
Bob

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can this code be made more efficient?	Mike Woodhouse[_2_]	Excel Programming	0	December 14th 06 03:24 PM
Can anyone help me convert to more efficient code?	slo	Excel Programming	2	August 4th 06 05:01 PM
Efficient Code	GregR	Excel Programming	7	June 27th 05 04:09 PM
More Efficient code than this	thom hoyle	Excel Programming	14	May 11th 05 07:40 AM
More efficient code	Rob Bovey	Excel Programming	1	July 9th 03 04:46 AM

All times are GMT +1. The time now is 04:09 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us