+ Reply to Thread
Results 1 to 6 of 6

Deleting blank columns/macro

  1. #1
    Registered User
    Join Date
    03-24-2010
    Location
    North West UK
    MS-Off Ver
    2013
    Posts
    90

    Deleting blank columns/macro

    Hi,

    I'm looking for a macro where it will delete all blank columns. I have to dump a lot of raw data in an excel file and sort it but it's taking absolutely ages to select each column and delete it, I'm looking for a quick fix.

    Over to you boffins!

    Thanks,
    Lew

  2. #2
    Valued Forum Contributor kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016/Work 2013 Pro Plus
    Posts
    627

    Re: Deleting blank columns/macro

    Can you attach a small sample workbook and explain what you need.

  3. #3
    Registered User
    Join Date
    03-24-2010
    Location
    North West UK
    MS-Off Ver
    2013
    Posts
    90

    Re: Deleting blank columns/macro

    I can but the raw data isn't standard so it's not something that I could record a macro to do as the empty columns change, I'm just looking for a piece of code that could, for example, look at the whole sheet and remove every column that has no data in any cells in columns.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2016
    Posts
    13,005

    Re: Deleting blank columns/macro

    try this:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-24-2010
    Location
    North West UK
    MS-Off Ver
    2013
    Posts
    90

    Re: Deleting blank columns/macro

    Perfect, that's going to help me out a lot.

    Thank you
    Lew

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2016
    Posts
    13,005

    Re: Deleting blank columns/macro

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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