+ Reply to Thread
Results 1 to 2 of 2

Macro to copy columns values

Hybrid View

  1. #1
    Mike_can
    Guest

    Macro to copy columns values

    Hi everyone, i need your help with this..
    I have a spreadsheet with 80 columns, and i need to insert 2 blank columns
    after each columns the spreadsheet would be like this:
    A B C D E F G H I J K
    1 5 7 9 11 50 70 30 25 15 17 5
    2 1 3 7 10 82 54 36 2 8 19 31
    3 2 8 60 90 45 85 74 15 55 87 84

    And i would need id like this:

    A B C D E F G H I J K L
    M N O P
    1 5 7 9 11
    50 70
    2 1 3 7 10
    82 54
    3 2 8 60 90
    45 85


    Thanks a lot



  2. #2
    Tom Ogilvy
    Guest

    Re: Macro to copy columns values

    Sub AddTwoColumns()
    Range("G:K").EntireColumn.Delete
    for i = 6 to 3 step - 1
    columns(i).Resize(,2).Insert
    Next
    End Sub

    --
    Regards,
    Tom Ogilvy


    "Mike_can" <Mikecan@discussions.microsoft.com> wrote in message
    news:DC4D9C46-0F4A-4A79-BBC7-8B56D6A0FDD2@microsoft.com...
    > Hi everyone, i need your help with this..
    > I have a spreadsheet with 80 columns, and i need to insert 2 blank columns
    > after each columns the spreadsheet would be like this:
    > A B C D E F G H I J K
    > 1 5 7 9 11 50 70 30 25 15 17 5
    > 2 1 3 7 10 82 54 36 2 8 19 31
    > 3 2 8 60 90 45 85 74 15 55 87 84
    >
    > And i would need id like this:
    >
    > A B C D E F G H I J K L
    > M N O P
    > 1 5 7 9 11
    > 50 70
    > 2 1 3 7 10
    > 82 54
    > 3 2 8 60 90
    > 45 85
    >
    >
    > Thanks a lot
    >
    >




+ 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