+ Reply to Thread
Results 1 to 3 of 3

Hide blank columns via loop

  1. #1
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    210

    Question Hide blank columns via loop

    Hi All,

    I've written below codes for automatically hiding blank columns via loop in the each worksheet of the current workbook, but it's not running well...

    Please Login or Register  to view this content.

    Can anyone please help me and correct the codes??
    Last edited by SunOffice; 06-09-2011 at 02:39 AM.
    Excelforum is Completely Awesome! True learning with Live Examples & Best Techniques!!

  2. #2
    Valued Forum Contributor MaczaQ's Avatar
    Join Date
    06-03-2011
    Location
    Poland
    MS-Off Ver
    Excel 2003 / XP
    Posts
    510

    Re: Hide blank columns via loop

    what you mean blank column ?
    you want to go through all cols and check if any data exists in current columns and if no data exist you want to hide this columns yea ?

    above conditions are coded into example file, please check it - for now works only in activesheet after press command button "test"

    Best Regards
    Attached Files Attached Files
    Last edited by MaczaQ; 06-09-2011 at 03:00 AM. Reason: update info :)

  3. #3
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    210

    Exclamation Re: Hide blank columns via loop

    Thanks for ur reply! ur codes are fine, but I hope you can understand what my below written codes say, and wht is my aim?

    Please Login or Register  to view this content.

    ....above my codes are just working fine up-to a limit, it hides all the columns via a loop, ...but I want to hide every blank column from the column E to the last column.

    P.S. Is there any method to hide the entire column or row in a veryhidden mode, so no-one can't see wht columns/ rows are hidden???
    Last edited by SunOffice; 06-11-2011 at 10:57 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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