Results 1 to 3 of 3

Show/hide rows based on drop down cell using named ranges

Threaded View

  1. #1
    Registered User
    Join Date
    02-04-2014
    Location
    Birmingham
    MS-Off Ver
    Excel 2007
    Posts
    2

    Show/hide rows based on drop down cell using named ranges

    hi

    I've found various threads showing how to hide/unhide rows based on a value in a cell and built a form based on the code I have found. The form has three uses and shows hides sections (rows) of the form dependant on the option selected in a cell (B1) This works fine but I now have a requirement for users of this form to add addtional rows into some of the sections but as they do this sections further down the form move down so subsequent sections then have different row numbers to that in the VB. I thought that I could use named ranges instead of row numbers but as soon as I put in the named range I get runtime 13 mismatch error?

    Please help.

    The attached sample has a drop down in cell B1 for options A, B or C and dependant on this selection, groups of rows are hidden.
    Each grouping of rows already has a named ranges (Range1 to Range5) but how do I use these in the VB?

    Many thanks

    Stuart
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Named Ranges don't show up in drop-down list
    By hds in forum Excel General
    Replies: 15
    Last Post: 10-16-2018, 06:26 PM
  2. Hide rows based on multiple ranges not containing certain value of referenced cell
    By markreisberg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2013, 05:26 PM
  3. Need help to show/hide rows based on values from a cell
    By concurmgr in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-19-2012, 02:56 PM
  4. [SOLVED] Hide/Show rows based on the value in a cell
    By PatRiot199 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-11-2012, 11:52 PM
  5. Toggle Hide/ Show Named Ranges
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2012, 06:33 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