+ Reply to Thread
Results 1 to 4 of 4

Delete entire Columns based on different Headers (Array)

  1. #1
    Registered User
    Join Date
    04-11-2013
    Location
    RC
    MS-Off Ver
    Excel 2007
    Posts
    10

    Delete entire Columns based on different Headers (Array)

    Hi,

    Trying to basically have certain Columns deleted based on the Header's title.

    This is my code so far, but I can't get it to work.

    Please Login or Register  to view this content.
    Basically any Columns from A:Z on the 1st row with Headers titled "Batch", "Straps", "Straps Verified" should be deleted but, VBA keeps skipping them.

    I know I'm missing something.

    Any help would be greatly appreciated, thanks.
    Last edited by WITJ; 05-13-2013 at 02:15 PM.

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

    Re: Delete entire Columns based on different Headers (Array)

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-11-2013
    Location
    RC
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Delete entire Columns based on different Headers (Array)

    Quote Originally Posted by AB33 View Post
    Please Login or Register  to view this content.
    Select Case! That's Brilliant! Thank you!

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

    Re: Delete entire Columns based on different Headers (Array)

    WITJ,
    You are welcome!

+ 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