+ Reply to Thread
Results 1 to 7 of 7

Hiding and unhiding rows - two scenarios

  1. #1
    Forum Contributor EdMac's Avatar
    Join Date
    01-23-2006
    Location
    Exeter, UK
    MS-Off Ver
    2003
    Posts
    1,264

    Hiding and unhiding rows - two scenarios

    I would like a range of rows (66-113) to be hidden by default.

    Scenario 1:
    If a cell (e65) has a value entered, row 66 will be unhidden. If cell e66 has a value entered, row 67 will be unhidden and so on.

    Scenario 2

    As above, Rows 66-113 are hidden by default
    User enters a number representing the number of rows to be unhidden in cell E7 - this number of rows is then unhidden commencing with row 66.

    Can any one advise how to code either or both these scenarios?

    Thanks

    Ed

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Both can be coded with worksheet events macros ...
    for example ...
    Please Login or Register  to view this content.
    HTH
    Carim


    Top Excel Links

  3. #3
    Forum Contributor EdMac's Avatar
    Join Date
    01-23-2006
    Location
    Exeter, UK
    MS-Off Ver
    2003
    Posts
    1,264
    Thanks for that Carim - I think it will do the trick.

    I have one small problem which is due to total ignorance on my part. I already have a
    Worksheet_Change(ByVal Target As Range) macro in this sheet - how do I insert a second one?

    Appreciate the help

    Ed

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    You cannot have two identical events for the same sheet ...
    The codings need to be combined into one ...

  5. #5
    Forum Contributor EdMac's Avatar
    Join Date
    01-23-2006
    Location
    Exeter, UK
    MS-Off Ver
    2003
    Posts
    1,264
    Ok - I'll have a go at that

    Ed

  6. #6
    Forum Contributor EdMac's Avatar
    Join Date
    01-23-2006
    Location
    Exeter, UK
    MS-Off Ver
    2003
    Posts
    1,264
    OK - I managed that and all is working.

    Thanks for the help Carim. I really appreciate the way that you don't just give out answers and make me use my brain! It's the best way to learn.

    All the best

    Ed

  7. #7
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Congratulations ...

+ 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