+ Reply to Thread
Results 1 to 4 of 4

Delete Blank Column Automatically

  1. #1
    Forum Contributor
    Join Date
    08-28-2012
    Location
    nz
    MS-Off Ver
    Excel 2010
    Posts
    125

    Red face Delete Blank Column Automatically

    Hi

    I have a dynamic graph that sometimes has a blank Column inserted

    What i would like if poss is the


    Blank Inserted Column Deleted Automatically


    Idea: "On Event"

    If Cells ("D2,D23") Blank Delete Whole Column ("D,D").



    Work Book Set Up with Auto Insert Blank Column


    Cheers to the Wizard how can help, in advance : )

    Thanks

    Mike
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Delete Blank Column Automatically

    Try this...
    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Contributor
    Join Date
    08-28-2012
    Location
    nz
    MS-Off Ver
    Excel 2010
    Posts
    125

    Re: Delete Blank Column Automatically

    Hi Thanks

    Tried it in WorkBook does auto Delete Blank Column but won't allow inserting of a Column with numbers just over writes ? Huh : )

    Upto you if you would like to fix I have got answer from


    http://www.vbforums.com/showthread.p...&is_resolved=1

    Cheers my mate
    Attached Files Attached Files

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Delete Blank Column Automatically

    both the codes (One in the link you provided and other provided by me) are same except the code in link is a sub routine. I wrote this code on worksheet change event because you wanted it to be a worksheet change event code otherwise both codes are doing the same thing.

    Please Login or Register  to view this content.

+ 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. Macro to delete blank rows if column I is blank for the row
    By tiger10012 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-10-2013, 03:01 PM
  2. Replies: 3
    Last Post: 07-17-2013, 01:25 AM
  3. [SOLVED] VBA Find last row and column that contain data and delete all blank rows and blank columns
    By bcn1988 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-03-2012, 01:07 PM
  4. Run Macro Automatically When delete row , changes cell,delete column
    By elevisse in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2012, 07:42 AM
  5. Delete content of selection in 1 column if other column is blank
    By chriswoon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-15-2010, 06:09 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