+ Reply to Thread
Results 1 to 3 of 3

Deleting multiple columns based on columns' first row value

  1. #1
    Registered User
    Join Date
    10-14-2013
    Location
    Saturn
    MS-Off Ver
    Excel 2010
    Posts
    28

    Deleting multiple columns based on columns' first row value

    Please Login or Register  to view this content.
    This macro is supposed to delete the columns with first row values = "Record Type", "Record indicator", ...etc.
    I'm getting mismatch error.
    Last edited by {=OR(value=array)}; 04-15-2014 at 04:54 PM.

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Deleting multiple columns based on columns' first row value

    You can use this code, but there are too many to list them. All you have to do is just add the criteria to line

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127

    Re: Deleting multiple columns based on columns' first row value

    Change your loop to the following:

    Please Login or Register  to view this content.
    NOTE: The code will throw an error whenever these fields are not found in your header row, so you may want/need to develop an error catcher.

+ 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] Copy/Paste multiple columns as values based on another columns criteria
    By Dgp2012 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-28-2013, 06:50 AM
  2. [SOLVED] Deleting Duplicates Based on Multiple Criteria from Multiple Columns
    By Franklic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2012, 05:31 PM
  3. 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
  4. [Macro] Deleting Columns Based on Multiple Conditions
    By fixedamage in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2006, 04:10 AM
  5. Deleting Columns Based upon Heading
    By Jessica in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-03-2005, 07:10 PM

Tags for this Thread

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