+ Reply to Thread
Results 1 to 6 of 6

Deleting blank columns/macro

  1. #1
    Forum Contributor
    Join Date
    03-24-2010
    Location
    North West UK
    MS-Off Ver
    2013
    Posts
    102

    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
    1,345

    Re: Deleting blank columns/macro

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

  3. #3
    Forum Contributor
    Join Date
    03-24-2010
    Location
    North West UK
    MS-Off Ver
    2013
    Posts
    102

    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,507

    Re: Deleting blank columns/macro

    try this:

    Please Login or Register  to view this content.
    Alan

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.

    Click on the star if you think someone helped you

    Have you debugged your code?
    Database Normalization
    Database Principles
    Move Data from Excel to Access
    DataPig Access Tutorials

  5. #5
    Forum Contributor
    Join Date
    03-24-2010
    Location
    North West UK
    MS-Off Ver
    2013
    Posts
    102

    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,507

    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