Results 1 to 21 of 21

Specific macro or VBA code to hide and unhide rows

Threaded View

  1. #1
    Registered User
    Join Date
    10-17-2013
    Location
    Ardooie
    MS-Off Ver
    Excel 2007
    Posts
    67

    Specific macro or VBA code to hide and unhide rows

    Hey everyone,

    This is my first question here, but I used the forum a lot before. Each time I found the answer, so I have good hopes for this one too
    I found a couple of similar threads about this, but none worked for me (probably because I don't know how to adapt the code).

    I have an empty col A
    I have a col B with names in it.
    I have a lot of other col from C to ... but those don't really mather here

    In col B, beside names, I have empty cells too ... These are for the users to add names.
    e.g.
    B3 to B11 = names already filled in
    B12 to B17 = empty cells

    My question about this is:

    If B12 is empty, B13 till B17 should be hidden rows.
    From the moment someone fills in B12, B13 shoud auto unhide, B14 till B17 stays hiden.
    If someone wants to fill in an extra name in B13 too, B14 = unhide, B15 till B17 = hiden
    And so on, and so on ... Note: B18: always visible because that's a new set of values that always must be visible.

    Hope that someone gets me, and that my English wasn't too bad
    PS: it's for Excel that I'm using @ work, so it's 2007.
    The attachment is another version of Excel, that's my home edition.

    Thanks in advance !

    Kristof
    Attached Files Attached Files
    Last edited by louvaek; 11-05-2014 at 11:28 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. use macro to find and replace specific code in vba
    By hopefulhart in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2014, 09:46 AM
  2. [SOLVED] Code to run a Macro on a specific day of the week at a specific time.
    By mjfox52610 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2013, 11:40 PM
  3. [SOLVED] Macro code to Copy specific rows into specific columns
    By macrofan2012 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-11-2012, 11:24 AM
  4. vba code to apply a macro to a specific tab
    By 2seas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-09-2012, 02:03 PM
  5. Assistance with Creating a Specific Macro using VBA code
    By Pbeer in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-17-2008, 05:35 AM

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