+ Reply to Thread
Results 1 to 4 of 4

Deleting Columns Based on Array

  1. #1
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    500

    Deleting Columns Based on Array

    Greetings,
    Thanks to the forum's help, I am using the following code to hide specific worksheet columns. However, I am actually needing to delete all the columns that do not equal the vArray range.
    Please Login or Register  to view this content.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,373

    Re: Deleting Columns Based on Array

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    500

    Re: Deleting Columns Based on Array

    TMS,
    I apologize for the late response - family emergency. Thank you much for your willingness to help. However, I just discovered after hours of trying to make this macro work, I do not need to delete the columns.
    Again, thank you!

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,373

    Re: Deleting Columns Based on Array

    You're welcome. Thanks for the rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Deleting few columns based on a criteria
    By laansesu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2015, 11:21 PM
  2. [SOLVED] Deleting columns based on the header
    By a94andwi in forum Excel General
    Replies: 12
    Last Post: 06-03-2015, 03:19 AM
  3. [SOLVED] Deleting columns based on cell value
    By Reapz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-03-2015, 03:57 PM
  4. [SOLVED] Deleting multiple columns based on columns' first row value
    By {=OR(value=array)} in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-14-2014, 04:00 PM
  5. Deleting Columns based on criteria in two rows
    By qdavhen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2011, 03:14 AM
  6. deleting rows based on value in columns.
    By barksmith in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-28-2009, 12:21 PM
  7. Deleting Columns Based upon Heading
    By Jessica in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-03-2005, 07:10 PM

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