+ Reply to Thread
Results 1 to 2 of 2

Cutting and inserting a column

  1. #1
    Registered User
    Join Date
    04-20-2010
    Location
    Holland
    MS-Off Ver
    Excel 2007
    Posts
    11

    Cutting and inserting a column

    I want to cut a column and put it at an other place in the same worksheet.
    Recording the macro gave me the following code which works perfect:
    Please Login or Register  to view this content.
    but after reading on the internet I find at multiple sites the advice to use this code
    Please Login or Register  to view this content.
    because it would be faster and uses less memory. And because I need to cut multiple columns I would like to optimize my code.

    The only problem is that this one line put's the the column at B instead of inserting and shifting the other columns. In other words: I loose the data which was original in column B.

    Any help would be appreciated.
    Last edited by Tjeu; 04-23-2010 at 09:53 AM. Reason: solved

  2. #2
    Registered User
    Join Date
    04-19-2010
    Location
    San Diego, CA USA
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Cutting and inserting a column

    Here you go. You don't need to select first in vba. This will speed you up a little.
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1