+ Reply to Thread
Results 1 to 5 of 5

Delete Alternate Column

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Delete Alternate Column

    Hello:

    I need a VB Macro to delete alternate column starting in column P.
    SO basically delete Column P,R,T,V....EH

    Please help and let me know if any questions.

    Thank you

    Riz Momin
    Last edited by rizmomin; 07-07-2013 at 10:15 PM.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Delete Alternate Column

    Hi, Riz,

    if you have solved the problem on your own you maybe should post the solution which worked for you - it might be of help for other users.

    My suggestion would be
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Delete Alternate Column

    another option
    Please Login or Register  to view this content.
    Last edited by patel45; 07-09-2013 at 01:28 AM.
    If solved remember to mark Thread as solved

  4. #4
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Delete Alternate Column

    Hi Hahobe and Patel:

    Both code will work for me.
    Thank you both of you.

    Riz Momin

  5. #5
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Delete Alternate Column

    Hi, patel45,

    Start is dimmed but not used, UsedRange is not necessarily the range columns need to be deleted in since it may start in A1 and not K1, the name you enter stays in the workbook.

    Please Login or Register  to view this content.
    Ciao,
    Holger

+ 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